![]() |
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