Prevent bypass of WorkbookOpen code?
Posted by JAF on February 12, 2001 4:45 AM
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.