Back in the days of ol2003, John Wallenbach's Power Programming book had a nice little procedure to build a drop down menu dynamically based on data in a spreadsheet tab. I modified his code and created a drop down menu generator (MenuMgmt) that worked in any MSOffice tool (data is still pulled into from an external xl spreadsheet/tab) and have used it continuously for 10+ years in both my applications and those I have developed for others.
With the arrival of Office2007 and the Ribbon/Fluent Interface, the approach still worked but the menu ended up in the Developers tab. After years of playing around with multiple versions of Office, I still hate the ribbon interface and much prefer the old drop down menu approach. Wallenbach's Power Programming for Excel 2007 summarized the dynamic menu situation with (something like) "it sucks". A few more tweaks to MenuMgmt added "popup" menus that worked a bit better in 2007+ applications but it was really a band aid.
A while ago I asked if any knew of a VBA procedure or set of procedures that could create or delete dynamically generated ribbon "tabs". Feedback was not encouraging.
I am now getting requests to rebuild some of my applications using the ribbon interface. Before I sit down and build a menu generator, I will ask again if anyone has or knows about a VB/VBA based ribbon tab creation procedure.
Thanks