Andy. That's a great ribbon editor Addin you created there and thank you for sharing.
So.. I have another topic going here that is related, but I decided on likely giving the User a general UserForm where they chose which menu's to load.
And in trying to keep on topic here with RibbonX and the GetVisibility, I'm trying to get 2 menus to load at the same time. So I have this in my RibbonX
Note: .... Is just to abbreviate the code. It is valid in CustomUI Editor.
And then in the VBA trying to load the Ribbon, I have something like this. Note, I'm looping Column B for a Value of 1, and Column A includes the "Audit" and "Tax" names.
I have this code, but it will only load 1 menu, and not multiple when I assign a 1 to each item.
Is this because the RefreshRibbon closes the first menu when opening the next? Or is it in the RibbonX and issues with InsertAfter?
In Trying to learn some more, I think the Rib.Invalidate clears the menu before rebuilding it. So is there a way to reload the menu with 2 or more New Menu tabs?
Bookmarks