When an Excel workbook that contains VBA code is idle for a while, it automatically opens the Visual Basic Editor (I believe on the last-entered Module). This is very confusing to people who have not seen the VB Editor before and who assume that their PC is under attack by a virus!
Why is this happening and is there a way to prevent it?
Thanks in advance.
Was the VBE maximized? The only thing I've been able to find on it so far is this:
http://groups.google.com/group/micro...76616b125725f0This is a known issue with VBE. It should only happen if VBE
was maximized before it was closed. If you restore the VBE window before
closing it and locking your workstation, this behavior should go away.
Michael Herzfeld
Office Programmability Test Team
I closed it by hitting "X", saved the workbook and left the Excel workbook open. When I returned to my PC after a while, it was open on the VBE window. Am I supposed to first minimize and then close the VBE panel?
Posting Permissions
Reply With Quote
