As we have been trying to point out:
There is no perfect way to protect Excel. Protection is the wrong word.
It is really a minor
safety feature that helps prevent messing with sensitive features of a
workbook.
There are ways to make it more difficult for users to have access to
sensitive areas - but few (if any) are perfect.
Greg has found a method that works well in his environment. So if you want
to add safety to your workbooks - take Greg's advice.
--
steveB
Remove "AYN" from email to respond
wrote in message
ups.com...
Worksheet and workbook (as opposed to file open) protection can be broken
in
seconds for those in the know. When I think of the people in my office and
in
See for example this simple code for unprotecting a password protected
worksheet, including a real life example:
Excel do not password protect sheets properly
http://www.pvv.org/~nsaa/excel.html#12
Regards
Nikolai