Issue with sequence of events: Workbook_open, Workbook_sheetActivate, and custom Ribbon

Hi all,

I created a custom ribbon which changes based on the worksheet based on information I got from Ron de Bruin. It took me sometime to figure it out as I kept getting an error which not directly related to the Ribbon customization per se.

When the workbook is opened, everything works fine. The issue occurs when I open the workbook. Upon opening the workbook, I use Workbook_open to perform some actions in the workbook but I also use Workbook_SheetActivate to change the customized Ribbon on the fly.

I believe the issue is that when workbook_open() is executed, the customized ribbon is not loaded yet. Upon opening the workbook, Rib = Nothing. Thus, my question is how can I handle the Workbook_SheetActivate to be executed after the workbook_open or similarly is there a way to force loading the customized ribbon as a first set in workbook_open().


In This.Workbook:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Kindest regards,

Dominic.

Originally Posted by JLGWhiz

If you think it is a timing issue, have you tried inserting a delay at the begiinning of your ribbon code?

Please Login or Register  to view this content.

This would give a 2 second delay before executing the rest of the code.

Or as you alluded to in your post, call the ribbon sub from your Workbook_Open event.

Thank you for your response! I will try this to check if it would have solved the problem. However, what I ended up doing was to create a global variable to control whether Workbook_open() is executed. This appears to be doing the trick.

Please Login or Register  to view this content.

Kindest regards,

Dominic.