View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Wayne Knazek Wayne Knazek is offline
external usenet poster
 
Posts: 51
Default Worksheet tabs as menu?

You can also make an Index Sheet. I made a table sort of looking index, and
used hyper links as the title for each tab.

So when you click on the name of a tab, you go right to that tab.

On each sheet I added a link to go back to the index page.

If I knew how to attach a file (or if you can) I'd send you a copy of my
worksheet. It's actually pretty cool. Lots of drop downs, comment windows
for instructions, etc.

Umm . . . I use 2003. So maybe some of what I did won't work on your
version. Like colored tabs. But I'd think most of it would work fine. :)