Is there a way to run a macro so that every time ANY (new or existing)
excel spreadsheet is opened, that it changes the default color palette
to a specific choice, i.e. "Custom 1"????

I have a custom palette I want to be the default regardless of whether
the workbook/spreadsheet file is a new - or existing - one.

Thanks much,
ga

George Applegate
c

Hi George

You can use a workbook template
Open a new workbook and change the things you want (Font/background color, font and font size and ?)

Then use FileSave As to save the file as a Template (xlt, in 2007 xltx or xltm) with the
name Book in the XLSTART folder.

You can find the Excel startup folder here
Note: this a hidden folder

C:\Documents and Settings\Ron\Application Data\Microsoft\Excel\XLSTART

Or in Vista
C:\Users\Ron\AppData\Roaming\Microsoft\Excel\XLSTA RT

With code you can find the correct path with this code line
MsgBox Application.StartupPath

Every workbook you a add is based on this template now.




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"George Applegate" wrote in message ...
Is there a way to run a macro so that every time ANY (new or existing)
excel spreadsheet is opened, that it changes the default color palette
to a specific choice, i.e. "Custom 1"????

I have a custom palette I want to be the default regardless of whether
the workbook/spreadsheet file is a new - or existing - one.

Thanks much,
ga

George Applegate
c