software

I'm trying to learn hoe to use a hyperlink to create a worksheet index. In
one spread sheet I've got about 35-40 tabs, thus the index idea.

Additionally, does anyone know how I can make my index always the sheet that
excel opens to upon opening this workbook.

David McRitchie posted this and it might help you:

=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,C5),C5)
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,sheetone!C5),sheeton e!C5)
=HYPERLINK(quot;#quot;amp;CELL(quot;addressquot;,'sheet two'!C5),'sheet two'!C5)

And you have another response at your other thread.

Jason - MR wrote:
gt;
gt; I'm trying to learn hoe to use a hyperlink to create a worksheet index. In
gt; one spread sheet I've got about 35-40 tabs, thus the index idea.
gt;
gt; Additionally, does anyone know how I can make my index always the sheet that
gt; excel opens to upon opening this workbook.

--

Dave Peterson