A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Visual Basic Editor opens automatically after lock, unlock compute



 
 
Thread Tools Search this Thread Display Modes
  #1  
Old August 2nd 06, 04:14 PM posted to microsoft.public.outlook.program_vba
Cowdozer
external usenet poster
 
Posts: 3
Default Visual Basic Editor opens automatically after lock, unlock compute

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/8290...d=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.

  #2  
Old August 2nd 06, 04:23 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Visual Basic Editor opens automatically after lock, unlock compute

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.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Cowdozer" wrote:

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/8290...d=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.

  #3  
Old August 2nd 06, 05:44 PM posted to microsoft.public.outlook.program_vba
Cowdozer
external usenet poster
 
Posts: 3
Default Visual Basic Editor opens automatically after lock, unlock com

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?

"Eric Legault [MVP - Outlook]" wrote:

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.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Cowdozer" wrote:

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/8290...d=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.

  #4  
Old August 2nd 06, 06:00 PM posted to microsoft.public.outlook.program_vba
Eric Legault [MVP - Outlook]
external usenet poster
 
Posts: 830
Default Visual Basic Editor opens automatically after lock, unlock com

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/


"Cowdozer" wrote:

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?

"Eric Legault [MVP - Outlook]" wrote:

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.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Cowdozer" wrote:

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/8290...d=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.

  #5  
Old August 4th 06, 05:22 PM posted to microsoft.public.outlook.program_vba
Cowdozer
external usenet poster
 
Posts: 3
Default Visual Basic Editor opens automatically after lock, unlock com

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

"Eric Legault [MVP - Outlook]" wrote:

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/


"Cowdozer" wrote:

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?

"Eric Legault [MVP - Outlook]" wrote:

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.

--
Eric Legault (Outlook MVP, MCDBA, MCTS: Messaging & Collaboration)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/


"Cowdozer" wrote:

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/8290...d=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.

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Visual Basic error in Outlook XP User Outlook - General Queries 3 May 7th 06 12:45 PM
Visual Basic and OE [email protected] Outlook Express 1 February 8th 06 01:35 PM
Visual Basic Editor opens automatically [email protected] Outlook - General Queries 0 February 6th 06 04:54 PM
Visual Basic Editor opens automatically [email protected] Outlook and VBA 0 February 6th 06 04:53 PM
how do Visual Basic Application (VBA) commands work Jason Outlook and VBA 2 January 10th 06 09:50 AM


All times are GMT +1. The time now is 03:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.