Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet Protection - Enhancement
Don't think so:
A) Worksheet protection is trivial to bypass. Once that occurs, the user can unlock a cell without ever triggering an event. B) Code can be bypassed simply by holding down the shift key when starting. C) Even if your code is protected, it's not encrypted. Using a Hex Editor on your file can easily find a password stored in a module (unless you also include some encrypt/decrypt routines). In article , Phil Hageman wrote: Is there a way with code to give more strength to worksheet protection, in addition to ToolsProtectionProtect **** ? Something like saying that changing any locked cell requires a password, which is contained in the code. The only way to change the cell would be to first comment out the code. Something like that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLookup Enhancement | Excel Worksheet Functions | |||
DATEDIF formula enhancement | Excel Worksheet Functions | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Excel Grouping Enhancement | Excel Worksheet Functions | |||
Worksheet protection is gone and only wokbook protection can be se | Excel Discussion (Misc queries) |