![]() |
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. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |