Organizing Tabs

[John Gregory]

I'm going to end up with a pretty busy spreadsheet that links to various
websites and other places on my computer. I there a way to make an outline
that can be minimized and left in a corner of the sceen that contains the
outline of the workbook with bookmarks to various tabs? If so, will someone
point me in the direction please?

 

[Dave Peterson]

You can right click on the VCR like controls at the bottom left and see all your
worksheets (and select from there).

Or you could use David McRitchie's Table of Contents macro to build that list of
worksheets/links.

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

 

[Tom Ogilvy]

You could probably create a menu structure that reflected the organization
of your workbook

Do you know how to customize menus? You would need to attach macros to them
to do the bookmark action.

You can also look at John Walkenbach's menumaker:
http://j-walk.com/ss/excel/tips/tip53.htm