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