unified
Posts: 13
Joined: 2009-06-14
|
How can I add a menu item to the Excel 2003 Tools Menu. I created an addin, and I am able to add my own menu item AdxMainMenu1 to the "Worksheet Menu Bar", then added a AdxCommandBarPopup with several AdxCommandBarButton items. But, I want to add my own AdxCommandBarButton to the existing Tools Menu, preferrably right above the "Macros" menu item. |
|
Eugene Astafiev
Guest
|
Hello Charles,
Here are the steps required to add a button in the Macro menu:
1. Add a context menu component to the add-in module.
2. Edit the Controls collection of the newly added component.
a. Add a command bar popup control and set its ID property to 30017.
b. Add a button to the popup control. |
|
unified
Posts: 13
Joined: 2009-06-14
|
|
Eugene Astafiev
Guest
|
You are welcome, Charles :D |
|