Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|