CustomUI Ribbon - change color of Button or what element is similar to the Excel 2013 Cell Style window

[anthonya2369]

I am trying to either change the background color of a button on a customUI ribbon control. However, I have researched Microsoft and it does not appear to be an option on button or any other element within the ribbon control. The other idea, which I do not know is possible, is the same type of element that displays the Cell Style window on the Home of Excel 2010/2013 which shows different types of cell style formatting just as Normal with green border, Bad in pink background, Good with Green background, etc. If I was able to display something similar to that with callback, that would work too. It appears to be some type of list/dropbox hybrid. Is this type of element available in CustomUI?

Thanks in advance.

 

[RickXL]

Hi,

Microsoft certainly like to make things difficult, don't they?

You can create an image and use it as a button. It looks as if you should be able to create multiple images and re-assign them dynamically using the getImage callback and I think you can.

The catch is that you cannot use images embedded in the workbook to do that. The images need to be in a folder somewhere on your computer then you can load the image via the callback.

Plan B would be to create several buttons and to hide the ones not in use. So it would look as if the button changed when, in fact, it was just displaying different buttons in the same space. I have tried this and it seems to work.

So it depends on whether you want the images to be in the workbook or external.