Whenever I open a password protected file, the password prompt appears and I am able to enter the password in to it for a second or two, then the prompt becomes unselected and typing is no longer effective even if I’m halfway through typing it. Only after clicking on the prompt can I continue entering the password. This only happens if I already have another Excel file open. It’s not really a problem, just a bit annoying.
The "other file" is not a specific file, but whenever I have any other Excel file already open. I'm 99.9% certain that the creator of the file did not add any sort of VBA code.
The "other file" is not a specific file, but whenever I have any other Excel file already open. I'm 99.9% certain that the creator of the file did not add any sort of VBA code.
Related posts:
1 response so far ↓
1 AQuestionMark // Sep 9, 2008
It doesn’t sounds like a normal excel running style, the other excel file probably has some VBA code that would run by itself, like a clock or timer which will update that file at constant intervals.
To get around that open the other excel file, Alt+F11 to go to VBA editor and change the code, add in the ThisWorkBook module a Private Sub Workbook_Deactivate() listening to opening of other workbook, and inside the sub, pause the running code.
Add in the ThisWorkBook module a Private Sub Workbook_Activate() that will resume the running routine again when the workbook is click and get back into focus again.
Please understand I don’t have the workbook in hand, so it’s really hard to provide a effective solution to the problem.
Leave a Comment