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.