Visual Basic Editor opens automatically after lock, unlock compute

[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.

 

[Guest]

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.

 

[Guest]

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?

 

[Guest]

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/

 

[Guest]

Thanks Eric, I'll try closing all the windows, subwindows, and editor panes
and hopefully it will stop.