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

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.

Hi Datanull,

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

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

---
Regards,
Norman



<datanull@gmail.com> wrote in message
news:1117217081.633053.269190@z14g2000cwz.googlegroups.com...
>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.
>

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
jim.coneXXX@rcn.comXXX



<datanull@gmail.com> wrote in message
news:1117217081.633053.269190@z14g2000cwz.googlegroups.com...
> 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.
>

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

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




"mastee" <mastee.1pr1qc_1117296301.7935@excelforum-nospam.com> wrote in
message news:mastee.1pr1qc_1117296301.7935@excelforum-nospam.com...
> 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