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.
Marc wrote:
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
|