Difference between xlSheetHidden and xlSheetVeryHidden

  • Thread starter gimme_this_gimme_that
  • 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 ?
 
R

Ron de Bruin

xlSheetHidden
You can unhide it in the userinterface

xlSheetVeryHidden
You can only change it in the properties or with VBA
 
B

Bernard Liengme

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
 
P

PA

xlSheetHidden is the "normal" hidding of the sheet
xlSheetVeryHidden is hidden even directly inExcel. The only to show this
sheet is through VBA.

PA
 
Top