View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default automatically create list of the worksheets

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 by Dave Peterson at Debra Dalgleish's site.

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

Or Bob Phillips' Browsesheets macro.

See this google search result.

http://tinyurl.com/yoa3dw


Gord Dibben MS Excel MVP

On Sun, 20 Jan 2008 05:04:03 -0800, Automatically create index of worksheets
<Automatically create index of wrote:

I would like to create basically an index or outline page with a list (and
hyperlinks if possible) of all of my worksheet titles or names.