Hide/show worksheet

[Mal]

Is there a way of automaticly hidind or showing a
worksheet. I have about 12 sheets on 3 different subjects
and would like to show the sheets only that I want to use
auto. I can use macros.
Thanks

 

[Bob Phillips]

There needs to be some sort of rule/criteria for determining what gets
hidden/shown, and when. What are those rules?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

There are 3 sheets that I would like to show at all
times. I would like the linked sheets to appear when I
enter one of these 3 sheets. EG when I clich on sheet
one, 7 of the linked sheets appear, click on another and
the first 7 dissapear and the new 6 appear.
Thanks
Mal

 

[Bob Phillips]

How do we know what are linked to the sheet?

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Guest]

The linked sheets have relivant data to one of the main 3
sheets.
Thanks
Mal

 

[Bob Phillips]

Sorry, but if you want a solution, you will need to be more forthcoming.
Relevant could mean any number of things. Code expects exact definitions.

--

HTH

RP
(remove nothere from the email address if mailing direct)