View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how do i create table of contents links/pg for multiple workbooks

Use hyperlinks to switch to the workbook of your choice.

David McRitchie covers TOC using hyperlinks at his site.

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

David's work is mainly on sheet navigation within one workbook but same
principles apply to multiple workbooks.


Gord Dibben MS Excel MVP

On Sun, 3 Jun 2007 12:41:00 -0700, JRoss
wrote: