D
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.
list of sheet names for the remaining sheets.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
How to create first sheet as a list of names of remaining sheets?
N
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
You might look at David McRitchie's 'Build Table of Contents' page at:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm
J
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)
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)
M
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
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
J
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
However, xl97 doesn't have that event.
See...
http://makeashorterlink.com/?G4451192B
Jim Cone
San Francisco, USA