Macro override password protection

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Copying in sheet with protection with the use of a macro 5
Protecting worksheet. 1
Protecting sheet in a macro doesn't work 1
How to bypass password when pasting FROM a protected workbook 3
Password protection worksheet 1
Use a password in VBA ActiveSheet.protect & ActiveSheet.unprotect? 2
Protecting & Unportecting the sheet. 5

Back
Top