Dyncamically change ribbon button image in Excel ( C#, XML)

Question

I made a customized XML ribbon for Excel in Visual Studio. The thing is that I want to change the ribbon-button images dynamically.

Either when a certain cell value has been changed the image is supposed to change or if a timer ticks.

My problem is that i can't find out how to access my certain button (there will be more than one button). I'm very thankful for any help.

Answer 1

You need to use the Ribbon XML markup. Declare the getImage callback for the buttons in the XML markup and add a corresponding event handler to the code. Call the Invalidate or InvalidateControl method of the IRibbonUI inteface when you need to change the image on ribbon controls. Your callbacks will be called where you can specify new images.

Read more about that (sample code is included) in the following series of articles in MSDN:

• Chapter 11: Creating Dynamic Ribbon Customizations (1 of 2)
• Chapter 11: Creating Dynamic Ribbon Customizations (2 of 2)

Also you may find the following ones helpful:

• Customizing the 2007 Office Fluent Ribbon for Developers (Part 1 of 3)
• Customizing the 2007 Office Fluent Ribbon for Developers (Part 2 of 3)
• Customizing the 2007 Office Fluent Ribbon for Developers (Part 3 of 3)