| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro override password protection
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
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Password protection in macro ( Anybody can view my password in VB | Excel Discussion (Misc queries) | |||
| Excel Data Protection- AKA: Sheet/Macro Password Protection | Setting up and Configuration of Excel | |||
| Can a Macro override sheet Protection? | Excel Discussion (Misc queries) | |||
| password protection macro - HELP???? | Excel Discussion (Misc queries) | |||
| How to add a macro with password protection | Excel Programming | |||
Hybrid Mode
