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



--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




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

What's the difference between xlSheetHidden and xlSheetVeryHidden ?

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

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

What's the difference between xlSheetHidden and xlSheetVeryHidden ?

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

PA

" wrote:

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

What's the difference between xlSheetHidden and xlSheetVeryHidden ?