Listing of Sheet names

[Will Fleenor]

I need a list of all the sheet names in my Excel 2003 files. The file has
lots of sheets and I want the listing in order to build a table of contents
(in the first sheet in the file) that contains hyperlinks to all the sheets
in the file.

Thanks, Will

 

[Norman Jones]

Hi Will,

See David McRitchies TOC page:

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