View Single Post
  #3  
Old June 7th, 2005, 01:40 PM
Dave Peterson
external usenet poster
 
Posts: n/a
Default

Maybe your macro should unprotect the worksheet, change the colors and then
reprotect the worksheet.

Cow wrote:

Hi there,

I had an Excel Macro program which was running very well in Office 97. But
after I had upgraded my Office 97 to Office 2003, I could not run part of the
program. I got the following error when trying to run the macro"
Run-time Error '1004' Unable to set the colorIndex property of the Font Class.

I noticed that the worksheet is actually write-protected. and if I try to
unprotect the worksheet and re-run the macro, it runs well...
Could anybody help me in this. Thanks a zillion


--

Dave Peterson