Document property

  • Thread starter Thread starter Edgar
  • Start date Start date
E

Edgar

Hi,

I would like to create a table of content in Excel. This
is based on the names of the different tabs.
In the file/properties/document contents the names of the
different tabs appear.

Instead of defining a name in each sheet, then in a
sepearate sheet create a hyperlink to these names,
is there a way/function to automatically use the
information from the document content property?

Thanks
Edgar
 
Are you aware of the built-in TOC that XL provides for sheet tabs?
If you right click in the scroll arrows that are to the left of the tab
names, you will see a list of approximately 15 sheet names.
If there are more, this list can be infinitely expanded to a scrolled TOC.

This list however, is in the order of the sheets as they appear in the WB.
They are not alphabetized, but I guess you could move the sheets around in
the WB manually, thus making this list alphabetical.

You might wish to look at David McRitchie's web page on this subject:

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


--


HTH,

RD
========================================
Please keep all correspondence within the Group, so all may benefit!
========================================
 
Back
Top