IRibbonUI object (Office)
The object that is returned by the onLoad procedure specified on the customUI tag. The object contains methods for invalidating control properties and for refreshing the user interface.
The IRibbonUI object does not generate events in its interaction with the user. Instead, ribbon elements perform callbacks to your code, and the linkage between ribbon elements and your code is defined in the XML that describes your ribbon additions.
For information about the callback functions available for each UI element, search for "How can I determine the correct signatures for each callback procedure?" in Customizing the 2007 Office Fluent Ribbon for Developers.
You can customize the Ribbon user interface (UI) by using callback procedures in COM add-ins. When the host application starts, the onLoad callback procedure is called. The callback procedure then returns a IRibbonUI object pointing to the user interface (UI). You can use that object to invoke the Invalidate, InvalidateControl, and Refresh methods.
In the following example, starting the host application triggers the onLoad event procedure that then calls a procedure that creates an IRibbonUI object representing the Ribbon UI. Next, a callback procedure is defined that invalidates all of the cached controls and then refreshes the UI.
<customUI … OnLoad="MyAddInInitialize" …>
Dim MyRibbon As IRibbonUI Sub MyAddInInitialize(Ribbon As IRibbonUI) Set MyRibbon = Ribbon End Sub Sub myFunction() MyRibbon.Invalidate() ' Invalidates the caches of all of this add-in's controls End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.