CODEWITHSUNDEEP
excelribbon
Adam Osborne
Adam Osborne

Reputation: 31

Custom Excel Ribbon background colors (like design with tables)

I have used CustomUIEditor to make many excel ribbons. I haven't been able to figure out how to change the background color of custom tabs I make. I'd like to change the background color of my tabs so they are noticeable as custom. I'm thinking of the same method excel uses when you click on a table and the color behind the design tab presents.

Like this:

enter image description here

Upvotes: 3

Views: 4995

Answers (1)

ChrisB
ChrisB

Reputation: 3225

While VBA can create and modify ribbons (and even add images) it can't change the overall color of the ribbon as seen when the ribbon is not selected.

To change the ribbon color, you need a COM add-in. COM add-ins are different than regular add-ins. Instead of using VBA (which at first glance looks like Visual Basic and is similar to an outdated version of VB), COM add-ins utilize modern Visual Basic or Visual C++.

How to write a COM add-in for Excel is beyond the scope of the question but here are some resources to get you started from Microsoft and Chuck Pearson:

About Excel COM Add-ins

Creating a COM Add-in

Customizing Ribbon Colors

Upvotes: 4

Related Questions