Thread: Excel 2000 = upgraded to 2003 and macro to change font color fail
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Donna L Bruce Donna L Bruce is offline
external usenet poster
  
Posts: 5
Default Excel 2000 = upgraded to 2003 and macro to change font color fail
----Additional information----

The error message I get is:
"Unable to set the ColorIndex property of the Font class."

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


"Donna" wrote:

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
Reply With QuoteReply With Quote