Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Unhide Worksheets (hidden via macros)
How do you unhide worksheets that were hidden via macros (or at least this is
what I am assuming happened). The option to unhide them via format menus does not work. |
#2
|
|||
|
|||
Mark,
It's probably very hidden. Yes, there is such a thing -- very hidden. Switch to the VBE (Alt-F11). In the Project Explorer at left, locate the workbook (use View - Project Explorer if you don't see the Project Explorer). Locate the indented sheet that seems to be very hidden, and select it. Open the properties window (View - Properties Window). Change the Visible property to 1 - xlSheetVisible. -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Mark" wrote in message ... How do you unhide worksheets that were hidden via macros (or at least this is what I am assuming happened). The option to unhide them via format menus does not work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks with hidden worksheets | Excel Discussion (Misc queries) | |||
excel macros truncating tabs for hidden columns. | Excel Discussion (Misc queries) | |||
unhide hidden window or workbook | Excel Worksheet Functions | |||
Why cannot I unhide the hidden rows ? | Excel Discussion (Misc queries) | |||
I can't unhide 3 columns previously hidden | Excel Discussion (Misc queries) |