Ribbon descativated after VBA crash

[alexak]

Hi..

I've an Excel 2007 worksheet with a personalized ribbon and some macros. Depending of the selected sheet, I enable (or not) the ribbon buttons depending of the shown information on the sheet. My macros sometime crashes and excel starts the vba debugger. After that, my ribbon boutons are not working any more: neither the associated procedure, nor the button enable runs. It seems to have lost the reference to the ribbon on the code.

I would appreciate any help.

 

[RoryA]

That can happen since your stored IRibbon variable has lost its value. You need to ensure that all your macros have error handlers.

 

[alexak]

Thanks Rorya for this quick reply. I'll try your solution.


Greetings