Modify Macro to show company's color palette

[IronCladRooster]

Greetings,

My company's branding standards have ten specific colors they want us to use on their marketing materials. I played around with changing the theme colors in excel, but I found the side effects of losing all of Excel's default colors to be a nuisance.

I found a terrific macro online which provides the exact functionality I'm interested in. It builds an icon or your ribbon or quick access toolbar which allows you to quickly pick a predefined color and apply it to the selected range. Here is the link to it:
http://spreadsheetpage.com/index.php...er_dialog_box/

However I cannot figure out for the life of me how to change the predefined colors from this macro. I would like to replace the predefined colors with my company's colors and apply them to the form for my easy access. How would I go about doing this?

Thanks

[6StringJazzer]

The code sets the colors to be the colors in the active workbook's color palette. This code is found in Module1 of the download file. To change the colors, you will have to write code to set the desired RGB color each of the buttons.

Original code:

Please Login or Register  to view this content.

Modify it to assign a specific color to each button:

Please Login or Register  to view this content.

[IronCladRooster]

Perfect! thanks so much Jeff, this will save me a good chunk of time!