View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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.