W
WimR
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
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