Listing of Sheet names
 

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

Hi Will,

See David McRitchies TOC page:

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

---
Regards,
Norman



"Will Fleenor" wrote in message
...
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