Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display hidden bubbles | Excel Discussion (Misc queries) | |||
Display Hidden Columns in Charts | Charts and Charting in Excel | |||
excel; display hidden chartrs | Charts and Charting in Excel | |||
unhide hidden column that won't display | Excel Discussion (Misc queries) | |||
How do I detect hidden worksheets or hidden data on a worksheet? | Excel Discussion (Misc queries) |