Visual Basic Editor Window Opens Automatically

[mikechambers]

Recently, I have noticed that my VBA editor window will automatically open
when unlocking my computer. I am running XP, with Office 2003. I unlock my
Windows using Ctrl-Alt-Delete, and type in my password. Then a VBA window
pops up. I have done some troubleshooting and here's what have found.

If I open a fresh session of Excel, lock my computer, unlock it, I get no
editor window pop up. But if I physically go into the editor, then close the
editor, lock/unlock my computer, then it will start popping up. Same with
Outlook. If I hav an Outlook session open which I have been in the editor at
one point since that session has been open, then I will get a pop up after
unlocking my computer. I will get a editor pop up window for each case. In
other words, one will pop up for Outlook, another for Excel, and for each
separate session of Excel (if I have manually opened the editor during that
sesssion at some point). So some times, I will have 3 or 4 editor pop ups
after unlocking my computer, and I have to close them all.

Now I also have a laptop, running on the same network, XP and 2003 Office,
and I cannot duplicate this issue. Nothing has changed on either to my
knowledge, but I don't even know where to begin checking for differences. Any
ideas???

Thanks!

 

[Jonmo1]

This is a common bug, no real solution. But I think it only happens if the VBA window is MAXIMIZED. If you unmaximize the vba window, and manually drag the window borders to the size you like, it won't happn anymore.

 

[mikechambers]

Wow! That fixed it. And I noticed on my laptop, my window wasn't maximized. As soon as I maximzed it on my laptop, it started doing the same thing. THANKS!

 

[Jonmo1]

No problem, it's a very strange bug indeed. But it is documented on Microsoft's support site. I have no idea what the window being maximized has to do with the Locking/Unlocking of the PC.

 

[craigexcel]

I encountered the same problem, and this solution worked for me too. Thanks!

 

[AnnieBrownTX]

This fix worked for me too, running Office 2010.
Thanks!!
Annie

 

[jumpjack]

Interesting bug.
Both bug and solution work on any VBA instance (outlook, excel, word,...).
Also resizing application bar causes the popup.
I have a double monitor, does it happen also on single monitors?

 

[Zappaz]

Worked for me!

Thanks

 

[bfrbouch]

I noticed that if I close Excel with the VB window maximized, a Microsoft Excel instance is "still alive" as shown in Task Manager as a background process. If I kill that instance it stops the behavior.
I also found that if I have the preview pane open in Windows Explorer that clicking an a .xlsx file (which is then previewed) will trigger the VB window to open.