List of Worksheets in a work book

[Bottle]

Can I keep a list of the worksheets in a workbook
displayed at all times (like the one you get when you
right hand click on the arrows in the bottom left hand
corner

Thanks

 

[Frank Kabel]

Hi
not really all the time but you could create a table of conetents sheet:
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

 

[Harald Staff]

Yes. See Dick Kusleika's code at
http://www.dicks-blog.com/archives/2004/08/23/sheet-names-in-a-dropdown-on-a-toolbar/

HTH. Best wishes Harald