Hyperlinking a specific worksheet ina workbook

  • Thread starter Thread starter toot033
  • Start date Start date
T

toot033

I am creating a large excel report and would like to add
some hyperlinks to different report to flesh it out. Is
there a way to hyperlink to a specific worksheet ( tab at
the bottom) rather thatn linking to the workbook and
having the recipents of the report select the tab. I am
using excel 2000.
Thank you in advance for any and all help on this problem.
Kris Krueger
 
Hi Kris,
Yes, =I think this was fixed in Excel 2002 where you don't have to
specify the pathname.

But it can be done in Excel 97 and up using #
Worksheets in VBA Coding and in Worksheet Formulas
(Coding a link address and friendly name using HYPERLINK Worksheet function )
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Then there are the object hyperlink (right click on a cell) that work without
the full pathname.
 
Back
Top