Table of Tabs

[Cyclewench]

Trying to create a "table of contents" of all my tabs in a worksheet. I've
seen this on other worksheets as a hierarchy list of tabs on the left of the
screen... like a folder view... any suggestions?

 

[Gord Dibben]

Rather than an index sheet with hyperlinks.......how do you get back to the
index sheet?.............try a sheet navigation toolbar or similar.

Sheet navigation bar from Debra Dalgleish's site.

http://www.contextures.on.ca/xlToolbar01.html

Or Bob Phillips' Browsesheets macro which I prefer.

See this google search result for Bob's code.

http://tinyurl.com/yoa3dw

Don't forget..........right-click on any of the navigation arrows at lower left
will give you a 15-sheet list and "more sheets" to pick from.


Gord Dibben MS Excel MVP

 

[Pete_UK]

David MacRitchie has a Build Table of Contents macro, available here:

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

Hope this helps.

Pete