Create/Modifying default colour palette in office

[shep6]

Our company uses 4 custom colour's for our corporate colour's, none of these are contained in the colour palette in Excel. Whenever we create chart's in Excel, we have to manually modify 4 existing colour's in the Colour's tab in Tools/Options. As we do this quite often, it is becoming a pain.

Does anyone know of a way of creating or modifying the default colour palette which excel (and the other office applications)uses.

Any help would be appreciated.

thanks

 

[Neddy]

Set up your worksheet with the modified colours as a template, and base all new worksheets on that template (put it in XLSTART to bring it up every time you start Excel).

 

[shep6]

Thanks Neddy

I have created a new workbook, changed the colours and saved it as a template in the same XLStart directory which my Personal.xls workbook is saved in.

You put in the reply that it should bring it up every time I start Excel. Should this happen automatically, as at the moment, I have to physically open the template.

cheers