David McRitchie posted this and it might help you:
=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheeton e!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
And David also has a macro that builds this kind of table of contents page:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
It's from Debra Dalgleish's site.
It builds a toolbar that you can use with any workbook to navigate to any
worksheet.
Dave F wrote:
Can someone help me understand this function's syntax?
Here's the situation: I have a workbook with a dozen tabs. I want to create
a thirteenth tab, called INDEX, which has hyperlinks to A1 of each tab.
If the first tab of my workbook is called Sheet1, I want the user to be able
to click on a link in the INDEX tab which takes him to cell A1 of Sheet1.
If I think of this in HTML terms, what I'm looking to do is something like
<a href="http://www.cnn.com/"Click here to go to CNN</a where the
"friendly" name 'click here to go to CNN' is a live link that takes you to
CNN.com.
Possible? I think so.
I'm using XL 2000 if that matters.
Thanks for your help.
--
Brevity is the soul of wit.
--
Dave Peterson