ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add menuitems to the VBE (https://www.excelbanter.com/excel-programming/303727-add-menuitems-vbe.html)

R Avery

Add menuitems to the VBE
 
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


All times are GMT +1. The time now is 08:33 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com