Hyper links

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

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

--
Regards
Frank Kabel
Frankfurt, Germany


Badger wrote:
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

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

"Frank Kabel" wrote in message ...
Hi
use something like the following as hyperlink reference
c:\temp\testfile.xls#sheet1!A1

--
Regards
Frank Kabel
Frankfurt, Germany


Badger wrote:
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

Badger wrote:
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