| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 . |
|
#4
|
|||
|
|||
|
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 . |
|
#5
|
|||
|
|||
|
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 . . |
|
#6
|
|||
|
|||
|
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 . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Indirect reference from one worksheet to another | Excel Worksheet Functions | |||
| Reference Data in Moved Worksheet | Setting up and Configuration of Excel | |||
| Worksheet name and Backward compatibility | Excel Discussion (Misc queries) | |||
Linear Mode
