Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide All VeryHidden Sheets in a workbook (w/o naming them)
I know how to hide sheets - veryhidden.
It requires me to name which sheets I want hidden... However, Any code to unhide ALL veryhidden sheets in a workbook - without naming them all? thanx |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unhide All VeryHidden Sheets in a workbook (w/o naming them)
Try this:
sub hiddensheets() dim ws as worksheet for each ws in worksheets if ws.visible = xlsheetveryhidden then ws.visible=xlsheetvisible next ws end sub "J.W. Aldridge" wrote: I know how to hide sheets - veryhidden. It requires me to name which sheets I want hidden... However, Any code to unhide ALL veryhidden sheets in a workbook - without naming them all? thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Help naming sheets | Excel Discussion (Misc queries) | |||
Please help me find veryhidden sheets | Excel Programming | |||
Validation OK to named ranges in Veryhidden sheets? | Excel Programming | |||
Naming multiple sheets in a workbook using cells within the workbo | Excel Programming | |||
naming sheets | Excel Programming |