MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Prevent bypass of WorkbookOpen code?


Posted by JAF on February 12, 2001 4:45 AM

Hiya

I have a file which automatically changes the FileAccessMode of the activeworkbook to ReadOnly if the workbook is opened between the 6th and 31st of the month (these being the dates when the file is effectively "locked").

The problem I have is that some crafty users with sufficient Excel knowledge have bypassed the Workbook_Open code by pressing the appropriate key (which I will not reveal here!!).

Is there any way to stop the users bypassing the Workbook_Open code even if the do press the <secret> key.


JAF


Posted by Celia on February 12, 2001 2:25 PM

JAF
Have a look at :-
Celia's Reply in 9550.html
Celia

Posted by Celia on February 12, 2001 2:59 PM

It might not work though when Worksheet_Open is bypassed with the keyboard.
Celia

Posted by Celia on February 12, 2001 3:08 PM

Also have a look at :-
Celia's Reply in 9273.html
Celia

Posted by Ivan Moala on February 14, 2001 6:23 AM

JAF

I have a routine that will take care of this....
even if they disable the macro prompt.

Ivan