set up an index linked to work book tabs

[James]

I would like to know how to set up the first page in a workbook as an index
tab to the rest of the work book, so when you click on a cell it opens the
tab which is linked back to the index tab.

 

[Dave Peterson]

Maybe you could use David McRitchie's Build Table of Contents to get the list
and the hyperlinks all at once:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

Another option if you want a more generic solution:
http://contextures.com/xlToolbar01.html
(From Debra Dalgleish's site.)

It builds a toolbar that you can use with any workbook to navigate to any
worksheet.

 

[Gord Dibben]

Try browsing through David McRitchie's Table of Contents pages for code and
methods.

http://www.mvps.org/dmcritchie/excel/buildtoc.htm


Gord Dibben MS Excel MVP