Setting a reference to the Ribbon

A

Andrew

I can get a reference to my customised ribbon and store it in a module
level variable using the following callback:
Public Sub rbxCustomUI_onLoad(ribbon As IRibbonUI)
Set mrbxRibbon = ribbon

However, if my code gets stopped (eg. due to a bug elsewhere) then the
variable holding the pointer to the ribbon goes out of scope. Is
there any other way to set a reference to the ribbon without needing
to close and reopen the workbook?

Thanks a lot,
Andrew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top