| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
a way to conditionally hide tabs in a range
Im not sure if this is possible but Im searching for a solution using a
control(selection of a cell) or button to take a range of worksheets, to first unhide all work sheets, then check a condition in one cell on each of the worksheets if the condition is positive then hide that sheet. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a way to conditionally hide tabs in a range
Try something like the following:
Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets If WS.Range("A1").Value = "Show" Then WS.Visible = xlSheetVisible Else WS.Visible = xlSheetHidden End If Next WS -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JWR" wrote in message ... I'm not sure if this is possible but I'm searching for a solution using a control(selection of a cell) or button to take a range of worksheets, to first unhide all work sheets, then check a condition in one cell on each of the worksheets if the condition is positive then hide that sheet. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a way to conditionally hide tabs in a range
Great Thanks for your help!
"Chip Pearson" wrote: Try something like the following: Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets If WS.Range("A1").Value = "Show" Then WS.Visible = xlSheetVisible Else WS.Visible = xlSheetHidden End If Next WS -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JWR" wrote in message ... I'm not sure if this is possible but I'm searching for a solution using a control(selection of a cell) or button to take a range of worksheets, to first unhide all work sheets, then check a condition in one cell on each of the worksheets if the condition is positive then hide that sheet. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
a way to conditionally hide tabs in a range
The code assumes that there will always be at least one sheet
that will be made visible. A workbook cannot have 0 visible worksheets. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JWR" wrote in message ... Great Thanks for your help! "Chip Pearson" wrote: Try something like the following: Dim WS As Worksheet For Each WS In ThisWorkbook.Worksheets If WS.Range("A1").Value = "Show" Then WS.Visible = xlSheetVisible Else WS.Visible = xlSheetHidden End If Next WS -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "JWR" wrote in message ... I'm not sure if this is possible but I'm searching for a solution using a control(selection of a cell) or button to take a range of worksheets, to first unhide all work sheets, then check a condition in one cell on each of the worksheets if the condition is positive then hide that sheet. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULA at Source range (in Data-validation-List) gives wrong re | Excel Worksheet Functions | |||
| Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
| Help with using range names in sum function | Excel Worksheet Functions | |||
| Array to named range conversion... | Excel Discussion (Misc queries) | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
Linear Mode
