Hide/show worksheet
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 |
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) "Mal" wrote in message ... 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 |
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 -----Original Message----- 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) "Mal" wrote in message ... 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 . |
How do we know what are linked to the sheet?
-- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... 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 -----Original Message----- 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) "Mal" wrote in message ... 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 . |
The linked sheets have relivant data to one of the main 3
sheets. Thanks Mal -----Original Message----- How do we know what are linked to the sheet? -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... 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 -----Original Message----- 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) "Mal" wrote in message ... 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 . . |
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) wrote in message ... The linked sheets have relivant data to one of the main 3 sheets. Thanks Mal -----Original Message----- How do we know what are linked to the sheet? -- HTH RP (remove nothere from the email address if mailing direct) wrote in message ... 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 -----Original Message----- 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) "Mal" wrote in message ... 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 . . |
All times are GMT +1. The time now is 12:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com