Excel 2003 Macro Error - Runtime error 1004

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

Office 2003 is more strict than earlier versions. You're going to have to
unprotect the sheet in the code:
Activesheet.unprotect
Range("Whataver").Font.Colorindex = ....
ActiveSheet.Protect

If there's a password, include it in the unprotect/protect lines
(Activesheet.unprotect "xyz")

Bob Umlas
Excel MVP

"Cow" <[email protected]> wrote in message
news:[email protected]...
> 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

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