Thanks Luke, I`ll give it a go.
RR1
I`ll get back once I`ve given it a try.
(may be some time!!!!!!!!!)

"Luke M" wrote:

I would suggest making a custom toolbar for the workbook, with buttons that
select your "main sheets". Each button would then have a short macro attached
to it. Check out this link:
http://www.contextures.com/xlToolbar02.html

For guidance on making a custom toolbar.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Romileyrunner1" wrote:

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