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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unhide sheet 2
macros to hide sheet with protection 1
hide & unhide toggle button 3
Unhide Multiple Sheets 2
when sheet is active macro is run 2
Hide and Unhide 0
hiding sheets 1
Hide, unhide macro 19

Top