ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting a reference to the Ribbon (https://www.excelbanter.com/excel-programming/442701-setting-reference-ribbon.html)

Andrew[_16_]

Setting a reference to the Ribbon
 
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


All times are GMT +1. The time now is 02:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com