View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default set up an index linked to work book tabs

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.