Fully load ribbon before showing Userform

[sharky12345]

I have a workbook with a custom ribbon that I've created using the Custom UI editor, and the workbook shows a userform on opening.

The problem I have is that the userform appears before the custom ribbon has fully loaded - is there a way around this?

If I close the userform the ribbon then shows as designed so wonder if there is a way I can force the ribbon to load fully before showing the userform.

 

[RoryA]

I'd suggest you use Application.Ontime in the Workbook_Open event to schedule the macro that loads the form. That should hopefully allow Excel to finish loading the ribbon before it loads the form.

 

[sharky12345]

Perfect, works a treat, thanks Rory....