Excel - Difference between xlSheetHidden and xlSheetVeryHidden

Asked By gimme_this_gimme_tha on 03-Mar-09 11:18 PM
When you are in the Properties Window and you have clicked on a
Worksheet:

What's the difference between xlSheetHidden and xlSheetVeryHidden ?




Bernard Liengme replied on 02-Mar-09 03:38 PM
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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
Ron de Bruin replied on 02-Mar-09 03:38 PM
xlSheetHidden
You can unhide it in the userinterface

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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm
P replied on 02-Mar-09 03:47 PM
xlSheetHidden is the "normal" hidding of the sheet
xlSheetVeryHidden is hidden even directly inExcel. The only to show this
sheet is through VBA.

PA