G Guest Jun 15, 2004 #1 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
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 Jun 15, 2004 #2 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.
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.
