LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 180
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
where did my old 2000 Excel macros go when I upgraded to 2003? dcampbe1 Excel Discussion (Misc queries) 2 April 4th 06 10:16 PM
Excel 2000 => upgraded to 2003 and Bar Chart Pattern disappeared Donna Charts and Charting in Excel 0 October 4th 05 08:28 PM
User-defined functions created in Excel 2000 fail in Excel 2003 goodguy Excel Discussion (Misc queries) 1 October 3rd 05 07:04 PM
Excel Macro to change row and font color based on column value MT[_2_] Excel Programming 4 September 1st 05 12:56 PM
Can Excel 2000 be upgraded alone to 2003 on an NT4 machine? Andymak252 Excel Discussion (Misc queries) 1 January 11th 05 11:53 AM


All times are GMT +1. The time now is 01:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"