Prev: Unlink chart from sheet
Next: Reply to Steve
From: Andrew on 20 May 2010 09:55
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
 | 
Pages: 1
Prev: Unlink chart from sheet
Next: Reply to Steve