I have a reasonable amount of experience in customising the Ribbon using the CustomUI editor and using VBA to dynamically populate menus. However, I just cannot seem to get my head around what I need to do to add a new Menu to an existing custom Tab using VBA.
I want to have a blank, already created Tab - I have already done that in the Custom UI editor.
I want to programmatically add new menu items to that Tab using VBA.
It would be useful to be able to know how to add a Tab programmatically as well but that is not essential.
Many thanks in advance for your help.
This is not a trivial project, since you also have to take care of all the housekeeping bits like editing .rels files to refer to any added XML. The CustomUI editor does this for you. While the learning curve is steep, in the long run it's easier to use C# or Visual Basic, Visual Studio and the Open XML SDK to programmatically add Ribbon mods.
BTW, you might be interested in a newer Ribbon editor that is available: RibbonX Editor