Display List of Tabs

[Jean Kipling]

Can I display in a worksheet, the list of tabs currently
in the worksheet? For example, user may have 25 tabs on a
worksheet & would like to display the names of the tabs on
a separate worksheet. <File> <Properties> <Contents>
isn't very print-friendly. Tks.

 

[Frank Kabel]

Hi
have a look at
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[Bob Phillips]

Jean,

Here's another way that throws up a dialog that lists the sheets, and you
can select one and activate it

http://tinyurl.com/2zvo3


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)