| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need macro from button to open selectable file | Excel Worksheet Functions | |||
| Button fails to call macro when open an Excel via Intranet | Excel Discussion (Misc queries) | |||
| comman button macro can't open worksheet | Excel Programming | |||
| Button fails to call macro when open an Excel file from web | Excel Programming | |||
| macro and button to open a word document from within excel | Excel Programming | |||
![michaelberrier[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
