Hi Mr. Low

You can create a template

Save a workbook with the font color and font size you want as Book.xlt (template)
Copy this file in your xlstart folder.

Where it is: You can find the file in the Excel startup folder
C:\Documents and Settings\<UserName\Application Data\Microsoft\Excel\XLSTART

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

Every new file you open now have the settings of this file


--

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


"Mr. Low" wrote in message ...
Dear Sir,

I do not have any problem in defaulting font type and font size for every
new file I open. I do it by going to Tool Option Font

Howeer when come to defauting the font color, I can default one file at a
time by going to Format Style. When a new file is opened, it goes by to its
original default font color of black.

May I know is there anyway to default it to blue color throughout for all
new files ?

Thanks

Low



--
A36B58K641