View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Macro override password protection

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.




In article ,
Cheryl wrote:

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