hide/Unhide sheet

M

Martin Seelhofer

Hi Shinya
Is it possible to hide sheet and don't display in the unhide list?

Type the following into the Immediate Window of the VB Editor:
ActiveSheet.Visible = xlSheetVeryHidden

Alternatively, you may adjust the property 'visible' in the properties-
Window of the VB Editor (select your Sheet-object in the Project
Explorer, first). This is also the easiest way to go to unhide a 'very
hidden' sheet.


Cheers,
Martin
 
Top