Create a default workbook with the custom color palette (look up
"default workbook" in XL Help).

In article ,
Ben Edwards wrote:

My old workbooks used an Auto_open macro that amended the colors available in
a spreadsheet such that one by one (by recording the actual change in tools
options etc. the new RGB numbers) so it matches our corporate colors (for use
in fonts, some text boxes, cell backgrounds, etc.). How can I load up our
corporate colors (RGB values) in my default workbooks automatically?