Display hidden worksheets

[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.

 

[Per Jessen]

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

 

[Duke Carey]

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.