MakeTable of Contents with VBA
 

I want to make a table of contents that will refrence the spreadsheet tabs
insert them into the TOC worksheet and hyperlink them automatically to their
corresponing sheet. This needs to work for any amount of spreadsheets. thanks
a bunch guys for your help.

MakeTable of Contents with VBA
 

Hi
use the HYPERLINK() function.
eg: say in book 'my book.xls' one titlle is cell B2 of sheet3
in the main sheet, enter:
=HYPERLINK("[my book.xls]sheet3!a1", sheet3!B2)

regards,
sebastien

"JakeR" wrote:

I want to make a table of contents that will refrence the spreadsheet tabs
insert them into the TOC worksheet and hyperlink them automatically to their
corresponing sheet. This needs to work for any amount of spreadsheets. thanks
a bunch guys for your help.

MakeTable of Contents with VBA
 

Jake

Try David McRitchie's TOC coding.

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

Gord Dibben Excel MVP

On Thu, 30 Sep 2004 14:55:03 -0700, "JakeR"
wrote:

I want to make a table of contents that will refrence the spreadsheet tabs
insert them into the TOC worksheet and hyperlink them automatically to their
corresponing sheet. This needs to work for any amount of spreadsheets. thanks
a bunch guys for your help.