| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ??
My code in the workook_open() macro includes the following to ensure
the workbook is protected at all times. ActiveWorkbook.Protect Password:=Range("adminpassword").Value When this code runs while the workbook IS protected, it actually causes the workbook to be UNPROTECTED. How strange is this ??!! Does anybody know why this happens and how I can prevent this from happening. I am running Excel 2003 thank you very much for your help. Wim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Running Macros in a protected workbook | Excel Discussion (Misc queries) | |||
| Help:Running a macro in one excel workbook from another workbook | Setting up and Configuration of Excel | |||
| Multiple workbook user's with Master workbook - all password protected | Excel Discussion (Misc queries) | |||
| Running Macros in protected workbook | Excel Worksheet Functions | |||
| Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming | |||
Threaded Mode
