There is a common problem when you are working with the Ribbon with RibbonX and VBA.
The ribbon object (which is initialized when Excel loads your file) can loose its reference
to the ribbon, which means your code can no longer tell Excel to update your ribbon customizations.
There is simply no easy built-in way to recover the handle to the Ribbon when there are problems
in or with your code. The only way to fix it is to close reopen your workbook, not a very user friendly way.
But MVP Rory Archibald came up with a great idea in a post in the MrExcel forum.
I created a example workbook based on Rory’s idea on the following page :
loss of state of the global IRibbonUI Ribbon object
If you have suggestion or comments let me know so I can add it to the page
Ron de Bruin