Finally got it to work.
I had to check to allow users to change cell formats in worksheet protection.

--
Donna L Bruce
Sr Technical Writer
Elster Electricity, LLC
Raleigh NC


"Donna L Bruce" wrote:

Tried the following:

Range("C9").Font.ColorIndex = 3

and got the same message Unable to set the ColorIndex property . . .

--
Donna L Bruce
Sr Technical Writer
Elster Electricity, LLC
Raleigh NC


"Simon Murphy" wrote:

Donna
Vb hasn't changed much, but sheet protection has, in 2003 you can prevent
cell selection
try
Range("C9").Font.ColorIndex = 3

and also check out what is protected, there are a few more options in 2003.
also consider protecting the user interface only if you are also wanting to
change things in code

cheers
Simon

"Donna" wrote in message
...
I have a spreadsheet with two macros that change the font color on a
specified cell in a protected worksheet based on some conditions. This
macro
worked fine in Office 2000 but now that I've upgraded to 2003 the macro
fails
at the Selection statement:

Range("C9").Select
Selection.Font.ColorIndex = 3

Has the VB changed between releases? Is there a work around for this?

Thanks
Donna L Bruce