Visual Basic Editor opens automatically after lock, unlock compute

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a problem in Outlook 2003 (and other Office 2003 apps).

If:
1. The application is open.
2. I have VBA macro code written.
3. The Visual Basic Editor is closed.

Then, if I lock my computer and then unlock it, the Visual Basic Editor for
that application opens up without menu bars and toolbars. This is a known
bug. (See article KB829059:
http://support.microsoft.com/kb/829059/en-us?spid=2520&sid=251)

It's not so much the missing toolbars that bother me, as it is the fact that
I have to close them whenever I come back to my computer after locking it up.
I typically have Excel open, as well as Outlook, so when I lock up my
computer to go away for a few minutes and then come back, I have up to 3
Visual Basic Editor windows open up:
One for Excel.
One for Outlook.
One for Word because it's my email editor?? I don't know!

Does anyone have a workaround or solution to this problem? Any help would
be greatly appreciated, because I have held off from deploying macros to
staff in my company because I don't want them to have to put up with this.
Also, if you don't ever have this problem, it would be helpful to know that
as well.

Thanks very much.
 
I've had this same problem for years with different Office versions and on
multiple computers. It looks like MS has known about this for a while, so I
doubt they'll ever fix it if they haven't by now.

The "ghost" editor should never be displayed if users are just running
macros; only if they are developing/testing them.
 
Thanks for the quick reply, Eric. I did a search for "ghost editor" because
I wasn't sure what you meant by that, and I came up on a couple of other
forums where you had talked about the same thing. I'm expecting that you've
coined that term yourself, is that true?

On one of the pages, I learned that Locking/Unlocking/Resizing the TaskBar
will cause the same effect. If it is true that "...The "ghost" editor should
never be displayed if users are just running macros..." then how do I tell
Outlook that I just want to be running them, and not developing/testing them?
 
Yeah, I guess I did come up with the "ghost editor" description of the
problem. I've actually had some success in making sure that I don't get the
ghost editor by always clearing all breakpoints and bookmarks and closing all
Module/Form windows, as well as the Project Explorer and Properties panes.

The option to dev/test macros in Outlook is always there, unless you have
disabled this via Group Policies (which I think is possible). Otherwise,
don't worry about it. If a non-programmer happens to stumble upon the VBA
Editor, I'm sure they'll quickly close it and never bother with it again.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/
 
Thanks Eric, I'll try closing all the windows, subwindows, and editor panes
and hopefully it will stop. :D
 
Back
Top