Using a macro and/or button to open the VBE
 

Is it possible to assing a macro and/or button to open the VBE? I know that
seems a little redundant, but I need to try.

Thanks to all.

Using a macro and/or button to open the VBE
 

Michael,
This seems to work:
Application.VBE.MainWindow.Visible = True

NickHK

"michaelberrier" wrote in message
...
Is it possible to assing a macro and/or button to open the VBE? I know
that
seems a little redundant, but I need to try.

Thanks to all.

Using a macro and/or button to open the VBE
 

Nick,
Thanks for the help. That opens the window but puts it behind the workbook.
what do I add to bring it forward?

Thanks again.

"NickHK" wrote:

Michael,
This seems to work:
Application.VBE.MainWindow.Visible = True

NickHK

"michaelberrier" wrote in message
...
Is it possible to assing a macro and/or button to open the VBE? I know
that
seems a little redundant, but I need to try.

Thanks to all.

Using a macro and/or button to open the VBE
 

Michael,
I don't program the VBE, so much of this is guesswork. Does this help:
Application.VBE.MainWindow.SetFocus

NickHK

"michaelberrier" wrote in message
...
Nick,
Thanks for the help. That opens the window but puts it behind the
workbook.
what do I add to bring it forward?

Thanks again.

"NickHK" wrote:

Michael,
This seems to work:
Application.VBE.MainWindow.Visible = True

NickHK

"michaelberrier" wrote in
message
...
Is it possible to assing a macro and/or button to open the VBE? I
know
that
seems a little redundant, but I need to try.

Thanks to all.

Using a macro and/or button to open the VBE
 

Perfect.
For future ref, it took something like this:
With Application.VBE.MainWindow
..Visible = True
..SetFocus
End With

I'm using it with a password taken from a userform, and that's what made it
work. Thanks again.

"NickHK" wrote:

Michael,
I don't program the VBE, so much of this is guesswork. Does this help:
Application.VBE.MainWindow.SetFocus

NickHK

"michaelberrier" wrote in message
...
Nick,
Thanks for the help. That opens the window but puts it behind the
workbook.
what do I add to bring it forward?

Thanks again.

"NickHK" wrote:

Michael,
This seems to work:
Application.VBE.MainWindow.Visible = True

NickHK

"michaelberrier" wrote in
message
...
Is it possible to assing a macro and/or button to open the VBE? I
know
that
seems a little redundant, but I need to try.

Thanks to all.

Using a macro and/or button to open the VBE
 

ALT+F11 already opens the VBE.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"michaelberrier" wrote
in message
...
Is it possible to assing a macro and/or button to open the VBE?
I know that
seems a little redundant, but I need to try.

Thanks to all.