Hello Ron,

The Excel 2002 I am using is installed at a server. It is a share program
use by large number of office staff.

The IT administrator disallow access to the program file. I am not able to
use the method you recommended.

May I know if there are some other ways of defaulting the font color ?


Kind Regards

Low

--
A36B58K641


"Ron de Bruin" wrote:

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