Reverse Engineering an Office Custom Toolbar

Question

I've "inhereited" an Excel Add-In which contains an Office 2000 custom Toolbar. Excel 365 places this on the "Add-Ins" Ribbon Tab,

I'd like to update the add-in so that the commands sit on a dedicated Ribbon Tab

While I can add a customUI to the template which creates the buttons that I need, what I can't seem to do is get at the button definitions in the custom Toolbar and find out what is actually being called when the buttons are clicked. (I have access to all the unberlying VBA - I'm just not sure how the toolbar was created)

Am I out of luck?

Answer 1

Toolbars were deprecated. You need to use a ribbon XML for creating a custom UI in Office applications. Read more about the Fluent UI (aka Ribbon UI) customizations in the following articles:

• Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3)
• Customizing the 2007 Office Fluent Ribbon for Developers (Part 2 of 3)
• Customizing the 2007 Office Fluent Ribbon for Developers (Part 3 of 3)

See How to add a custom Ribbon tab using VBA? for the sample code.