Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting Display of Keyboard Shortcuts in MenuBar and/or Ribbon | Setting up and Configuration of Excel | |||
Setting a cell with a value as a reference for another function | Excel Worksheet Functions | |||
Setting VBA reference programmatically | Excel Programming | |||
Setting Reference to another WorkBook-Problem | Excel Programming | |||
Setting up Reference Library using VBA | Excel Programming |