View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Romileyrunner1 Romileyrunner1 is offline
external usenet poster
 
Posts: 73
Default Hiding tabs for just some sheets.

Hi,
how would I hid some worksheet tabs but not others.
I have about 12 main tabs that I need to show for navigatio purposes. Then I
will have 80 subsiduary sheets that I want to navigate to from a `masterpage`
using hyperlinks.
Having played about with this a bit, the problem is that when I navigate to
lets say subsiduary sheet 20 from the master sheet, the tabs scroll across
the bottom and now I can`t easily get back to my first and most important
worksheet pages. I have to rescroll back left to get them in view again.

Any ideas people?
Many hanks.
RR1