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

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