Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I conditionally hide a worksheet
I would like to have different worksheet tabs that are only viewable based on
answers given on a main page. Say I have 4 conditional pages, based on 1 of 4 answers given on that main page only one would be viewable and the other three would remain hidden. Is this even possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I conditionally hide a worksheet
I don't know of a way to do that with a formula, but you could use a
worksheet change macro like this: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = Range("B7").Address And Target.Formula = "Hide" Then Worksheets("Sheet2").Visible = False End If End Sub It will hide Sheet2 if B7 is changed and it is changed to the word Hide. Don't forget to write a way for it to return ;) On Jun 17, 2:34 pm, Jeremehovah wrote: I would like to have different worksheet tabs that are only viewable based on answers given on a main page. Say I have 4 conditional pages, based on 1 of 4 answers given on that main page only one would be viewable and the other three would remain hidden. Is this even possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) | |||
Way to conditionally hide rows? | Excel Worksheet Functions | |||
a way to conditionally hide tabs in a range | Excel Discussion (Misc queries) | |||
Is there a way to conditionally hide a row? | Excel Discussion (Misc queries) | |||
Conditionally Hide Rows | Excel Discussion (Misc queries) |