Difference between xlSheetHidden and xlSheetVeryHidden

  • Thread starter Thread starter gimme_this_gimme_that
  • Start date Start date
G

gimme_this_gimme_that

When you're in the Properties Window and you've clicked on a
Worksheet:

What's the difference between xlSheetHidden and xlSheetVeryHidden ?
 
xlSheetHidden
You can unhide it in the userinterface

xlSheetVeryHidden
You can only change it in the properties or with VBA
 
I believe that a sheet hidden by xlSheetHidden can be unhidden by a user
working within the Excel interface. But one that is 'very hidden' needs VBA
to unhide it. Its like 'secret' and 'top secret' <grin>
Do a simple experiment to check my memory!
best wishes
 
xlSheetHidden is the "normal" hidding of the sheet
xlSheetVeryHidden is hidden even directly inExcel. The only to show this
sheet is through VBA.

PA
 

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

problem macro to show a warning sheet... 4
error in attempt to warn about macro security 6
worksheets.select doesn't work 4
Closing running sub from a different one 3
Workbook_BeforeClose 3
xlSheetVeryHidden vs xlSheetVisible 11
Workbook_BeforeClose 2
Hierarchy of Codename and error catching if no worksheet. 1

Back
Top