Sheet hidden and VeryHidden

[Marc]

What is difference between sheet Hidden and Very Hidden?

Thanks

 

[Dave Peterson]

The biggest difference is whether the user can see (and show) the worksheet via
the:

Format|sheet|Unhide dialog

 

[Guest]

And that you can make a sheet very hidden only via VBA

 

[Dave Peterson]

Or manually via the VBE (in the properties for that worksheet).

 

[Guest]

hmmm, yeah. I kinda sorta forgot about that.

Or manually via the VBE (in the properties for that worksheet).

 

[Marc]

The biggest difference is whether the user can see (and show) the
worksheet via

the:
Format|sheet|Unhide dialog

If I have Very Hidden sheets, and protect sheet, workbook and VBA project
with password, and someone unprotect sheet, he has to unprotect also VBA
project so that he can see sheets?

Thanks

 

[Dave Peterson]

Many users have their own personal macros that can make worksheets visible.

If you want to make it a little more difficult, then when you protect the
workbook:

Tools|Protection|protect workbook
make sure you check that Structure checkbox.

But there is code that is freely available that can remove the worksheet
protection and workbook protection in a matter of moments.

The VBA project protection won't even come into play for this.

And protecting a worksheet doesn't affect the visibility of that worksheet.