Access Add-In Ribbon from Code

[BenW71]

I need to be able to get a reference to a ribbon that is part of an add-in to invalidate / refresh buttons at times.

I have a module level public variable defined and instantiated when the workbook opens as such...
In the XLAM CustomUI declaration:

<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui" onLoad="MyAddInInitialize" >

In a workbook module:

Public MyRibbon As IRibbonUI

Sub MyAddInInitialize(Ribbon As IRibbonUI)
    Set MyRibbon = Ribbon
End Sub

However sometimes (and i don't know why) the myribbon variable becomes Nothing after being used for a while. I don't really know why...

Instead of tracking down why the variable is being lost which is a valid question but i may not need to solve it, is there a way to access the ribbon object by name or any other object tree? So in the XLAM code modules i could do something like MyWorkbook.Ribbons("blah") or whatever to get the variable?

The ribbon still exists, it is clickable and the actions fire... I just don't have a global variable that i can call to refresh the buttons...

Thanks in advance.

 

[Domenic]

Have a look at @RoryA 's solution in this following thread...

How to preserve or regain the Id of my custom ribbon UI?

I have a little Excel 2007 application with a standard ribbon UI. See the CustomUI.xml and the VBA-code below. I have uploaded an Excel 2007 TestRibbonUI.xlsm to box.net from where you can get it with the link http://www.box.net/shared/8uznug7s3r My new tab with name "My Tab" and...

www.mrexcel.com

Hope this helps!

 

[BenW71]

Have a look at @RoryA 's solution in this following thread...

How to preserve or regain the Id of my custom ribbon UI?

I have a little Excel 2007 application with a standard ribbon UI. See the CustomUI.xml and the VBA-code below. I have uploaded an Excel 2007 TestRibbonUI.xlsm to box.net from where you can get it with the link http://www.box.net/shared/8uznug7s3r My new tab with name "My Tab" and...

www.mrexcel.com

Hope this helps!

Thank you Domenic, this does indeed look like the solution to my issue!

Marking as the solution

 

[Domenic]

You're very welcome, cheers!