Hi Everybody

Because, as a company policy, all the computers are supposed to auto-lock themselves if there is no activity that is registered by the computer for a specifed length of time. This is very annoying when I am running some of my Excel VBA based applications that run for extended periods of time with the VBE closed. The reason is that once the computer auto-locks itself and and I subsequently enter the password and log back in to the system, I cannot get back to the Excel application. The only way that I can get back to the Excel application is by interrupting the VBA code which activates the VBE and the program can then only be continued from within the VBE.

This is something I do not want to happen, for two (2) reasons :-
1. that I am led to believe (but I haven't got any hard evidence to prove it to be correct or otherwise) that with the VBE activate, the VBA programs run a lot slower and
2. that the status bar can now not be made visible during the running of the program. It is important that the status bar is visible for the whole duration that these VBA based applications are running since they convey important messages to the user.

Does anyone has any suggestions as to what can I do to make the computer register some activity so that the auto-lock doesn't get activated. For example, would making a different cell show or selecting a cell through VBA count as some activity or does it need to be manually done by the user for the computer to register it as a physical activity?

Any suggestions please! This is driving me crazy and apparently there can be no exceptions to this company policy with reference to the Network Security.


Thanks in advance.


Best regards


Deepak Agarwal