How to create first sheet as a list of names of remaining sheets?

[datanull]

I want the first sheet to be a TOC of sorts with one column that is the
list of sheet names for the remaining sheets.

 

[Norman Jones]

Hi Datanull,

You might look at David McRitchie's 'Build Table of Contents' page at:

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

 

[Jim Cone]

or...

My Excel add-in "Excel Extras" -Table of Contents- utility
adds a new sheet to the workbook with a list of sheet names
and the number of printable pages for each sheet.
Each sheet name is hyperlinked to the actual sheet.

The add-in has other features including:
Sheet sorting
Print area determination
Batch Hyperlink removal
Header and Footer - adding info or clearing
Font options
Comes with a Word.doc install/use file.

It is available - free - upon direct request.
Remove xxx from my email address

Regards,
Jim Cone
San Francisco, CA
(e-mail address removed)

 

[mastee]

Hi,
can someone help me i want to create a index sheet with all the
hyperlinks and hide the worksheets after that .When i click the
hyperlink the hidden worksheet should open and allow me to print the
sheet.

I WILL BE GRATEFUL IF SOMEONE AN HELP ME ON THIS MATTER.
Mastee

 

[Jim Cone]

You can use the FollowHyperlink event in your index sheet.
However, xl97 doesn't have that event.
See...
http://makeashorterlink.com/?G4451192B

Jim Cone
San Francisco, USA