Unhide All VeryHidden Sheets in a workbook (w/o naming them)

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
J

J.W. Aldridge

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
 
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
 
Back
Top