Macro override password protection

C

Cheryl

After I record protection & unprotection of all my worksheets with a password, macros erase my passwords. The sheets can be unprotected with no passwords by user! Please help
 
J

JE McGimpsey

Worksheet protection is worth using only for keeping users from
inadvertently messing up the sheet. See

http://www.mcgimpsey.com/excel/removepwords.html

You can add all kinds of other roadblocks, but they won't keep anyone
who can open your workbook from accessing the worksheet.

If you and all your users have XL2003 and have access to Server2003, you
can try using XL03s digital rights management limits.
 
Top