Hyper links

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Badger - 26 Oct 2004 09:09 GMT

How do i reference a specific worksheet in an excel workbook in a hyper link.
(when i follow the link it brings up the specified worksheet in the
workbook).

What is the syntax for the hyper link that references a specifc worksheet ?

Thanks

Reply to this Message

Frank Kabel - 26 Oct 2004 15:07 GMT

Hi
use something like the following as hyperlink reference
c:\temp\testfile.xls#sheet1!A1

Signature

Regards
Frank Kabel
Frankfurt, Germany

> How do i reference a specific worksheet in an excel workbook in a
> hyper link. (when i follow the link it brings up the specified
[quoted text clipped - 4 lines]
>
> Thanks

Reply to this Message

David McRitchie - 26 Oct 2004 17:20 GMT

Just in case there is some ambiguity.

If the reference is in the same workbook then you would
use the part starting with the # in object hyperlinks or in Worksheet Formulas

in Ctrl+K edit hyperlink
#Sheet34!E6

or in a HYPERLINK Worksheet Formula
=HYPERLINK("#Sheet34!E6",Sheet34!E6)

More information in
http://www.mvps.org/dmcritchie/excel/sheets.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

> Hi
> use something like the following as hyperlink reference
[quoted text clipped - 8 lines]
> >
> > Thanks

Reply to this Message

Bill Manville - 26 Oct 2004 17:41 GMT

> How do i reference a specific worksheet in an excel workbook in a hyper link.
> (when i follow the link it brings up the specified worksheet in the
> workbook).

#SheetName!CellReference

e.g. #Sheet1!A1

following the file name

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Reply to this Message