VB Editor Menu Keyboard Shortcut Assignments Change with Macro / Code …

[AreJay]

Within the “VB Editor” of Excel and Word, can you change the top menu / toolbar keyboard shortcut assignments that have been created and currently use upon loading … with a VBA macro of some sort?

There are several VB Editor keyboard assignments I have been using for years for other menu choices, but I have several VB Editor add-ins that use the same menu assignments that use an ampersand “&” to
assign various Alt-? keys.

I manually change these each time I load Excel or Word. However, when closing or restarting either program, they default back, and have to be changed each time.

I have reached out to the add-in providers, to no avail for a solution.

Thank you.

[SamT]

You will need to use the VBIDE (References: Microsoft Visual Basic For Applications Extensibility V.v) Basically coding another Add=in, but this "Add-in" can reside in Personal.xlsm or Word.docm. You will probably use the VBE Object, the VBE.CommandBars Collection Object and the VBE.CommandBarsEvents Object and Initiate it with the Personal.ThisWorkbook_Open() Event or Word_Open()

I would be interested in seeing what code you come up with, as there are a couple Commands I would like to add to my VBA Editor.