PDA

View Full Version : When "idle" Excel workbook opens Visual Basic Editor



K. Georgiadis
04-30-2007, 06:16 AM
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.

vonpookie
04-30-2007, 07:45 AM
Was the VBE maximized? The only thing I've been able to find on it so far is this:


This 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
http://groups.google.com/group/microsoft.public.office.developer.officedev.other/browse_thread/thread/1d5389bdb411bb67/db76616b125725f0

K. Georgiadis
04-30-2007, 07:52 AM
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?