Display hidden worksheets

  • Thread starter Thread starter zindtx
  • Start date Start date
Z

zindtx

Please tell me there's a way to display multiple hidden worksheets with one
command. Must one open the "Unhide" box to display each worksheet? I've
hidden 27.
 
Hi

This macro will make all sheets in the workbook visible.

Sub MakeSheetsVisible()
For Each sh In ThisWorkbook.Sheets
sh.Visible = True
Next
End Sub

Press ALT + F11 to open the macro editor, then goto Insert > Module.
Copy the code above into the module and run it.

Best regards,
Per
 
You can download Excel Utilities from Rob Bovey's www.Appspro.com site

It has a number of helpful tools on its own toolbar and menu. One such is
unhide all sheets. Plus, it remembers which ones were hidden and can then
re-hie the same ones.
 
Back
Top