Frequently used company colors

[Nate Ondricek]

Hello,

At the company I work for I have a set of 10 colors which we are supposed to use for all our marketing materials. Every time I start a new spreadsheet I have to go through and manually go through the advanced color selection process to select the RGB color code.

I want to find a way for Excel to save these 10 "frequently used colors", but do so without losing the default Excel color scheme. I've explored the concept of building a custom theme with a custom set of colors, despite the limit of only 6 colors, but I can't stand to lose all those Excel defaults, as I use those as well.

I've read online about using a color picker dialogue box through VBA like the one listed here: http://spreadsheetpage.com/index.php/tip/creating_a_color_picker_dialog_box/
but I don't know how to choose which colors show up in this box.

Any ideas?

 

[AVK]

for better result upload file with output result.

 

[NARAYANK991]

Hi Nate ,

Go through the Excel help on the following :

Workbook.Colors Property

What this does is it returns or sets colors in the palette for the workbook. The palette has 56 entries, each represented by an RGB value.

The example given there is :

ActiveWorkbook.Colors(5) = RGB(255, 0, 0)

This will reference the palette in the active workbook. If you use :

ThisWorkbook.Colors(5) = RGB(255, 0, 0)

it will reference the workbook which has this code in it.

Narayan