| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2000 = upgraded to 2003 and macro to change font color fail
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 = upgraded to 2003 and macro to change font color fail
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 = upgraded to 2003 and macro to change font color
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel 2000 = upgraded to 2003 and macro to change font color
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where did my old 2000 Excel macros go when I upgraded to 2003? | Excel Discussion (Misc queries) | |||
| Excel 2000 => upgraded to 2003 and Bar Chart Pattern disappeared | Charts and Charting in Excel | |||
| User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel Macro to change row and font color based on column value | Excel Programming | |||
| Can Excel 2000 be upgraded alone to 2003 on an NT4 machine? | Excel Discussion (Misc queries) | |||
Linear Mode
