Closing the VBA Editor using code

Hi all,
One of my macros leaves the VBA Editor window open after
execution. Is there a way to close it without using Alt
F11??

Thanks for any help!

Regards,
Bony_Pony

You can use SendKeys to send these keystrokes. Look it up in Help.

But why and how is your macro opening the VBEditor window? I would find the
answer to that question, then don't open it in the first place.


On Mon, 7 Mar 2005 10:18:57 -0800, "Bony_Pony"
<anonymous@discussions.microsoft.com> wrote:

>Hi all,
>One of my macros leaves the VBA Editor window open after
>execution. Is there a way to close it without using Alt
>F11??
>
>Thanks for any help!
>
>Regards,
>Bony_Pony