Display hidden worksheets
 

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.

Display hidden worksheets
 

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

"zindtx" skrev i meddelelsen
...
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.

Display hidden worksheets
 

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.

"zindtx" wrote:

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.