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.

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.

James wrote:

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

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

On Tue, 12 Sep 2006 14:38:02 -0700, James
wrote:

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.