Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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" wrote in message ... 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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LINEST bug with cubic polynomials in Excel 2003 | Excel Worksheet Functions | |||
macro in excel 2003 | Excel Worksheet Functions | |||
update row numbers after different active cells in macros followi. | Excel Discussion (Misc queries) | |||
sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) |