It would be easier to demonstrate this error than describe it!
I am working on a XLSM file which has a custom ribbon tab, hide-able standard tabs and dynamically sized dropdowns on the menu buttons. Everything appears to be working how I want it except for one thing. If I trigger a loss of ribbon state, the ribbon recovers however whichever dynamically sized dropdown menu button I was on does not auto recover.
To reproduce the issue:
- Download attached workbook
- Open the file (There is no developer tab. Alt + F11 to get to the VBA editor)
- Click the button 'Test Ribbon for recovery from Loss of State'
- Click the End button (this will trigger the macros for recovering the ribbon)
- Now click on any of the Menu Labels (1-8)
Whichever Menu Label was clicked on first will display a blank dropdown list. Now click any of the others - these recovered fine.
Any ideas how to prevent this happening?
Bookmarks