In response to the question of :
I am wondering if the VBE can be directly programmed to solve this problem?
The answer unfortunately is negative.
The only way to modify the behavior is by using
whose capabilities are summed up by Microsoft as :
- A startup module to trap the opening and closing of the add-in.
- Some code to add our menu items to the commandbars on opening and remove them when closing
- For the VBE, a class mosule to handle the menu items "Click" events
- Some code to perform your menu's actions.
Specifically, intercepting hotkeys is not in the list.
The answer by Eliyahu is then still correct, and AutoHotKey (or AutoIt)
is still the only solution.