Add menuitems to the VBE

R

R Avery

How do I add a menuitem to the VBE that can execute a macro that I specify?

Also, does anyone know a keystroke combination that will close the
Immediate Window? Since I often have to toggle back and forth between
the Code Pane and the Immediate window, I use CTRL-G and F7 ... but i
also want to be able to close the immediate window completely. Is this
possible without writing a custom macro (like the one below)?


Public Sub AAACloseImmediateWindow()
Application.VBE.ActiveWindow.Close
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Improving Macro That Keeps First Letter 0
Keep First Letters, with exceptions 0
Immed Win: how to home down and clear? 3
Add menuitem to the VBE 0
Excel 2007 - Moving around in VBE 1
Select Text to End of Footnote 9
Auto code in VBE when pressing F7 6
Hyperlink fails to open on the first click 0

Top