View Single Post
  #4  
Old November 21st, 2010, 11:43 PM
speedypcnet speedypcnet is offline
Member
 
First recorded activity by OfficeFrustration: Nov 2010
Posts: 1
Thumbs up

Quote:
Originally Posted by Cow View Post
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
Hi,

The most common Runtime Error is 1004. This error is very generic and is often used to describe a variety of different errors. As such, when you see the Runtime Error 1004, it could be caused by any number of things, just in Microsoft Office.

You can fix this runtime problem on your own within your Windows system. Follow the instructions below:

- Select the "Start" button.
- Choose "Explorer" from the menu provided.
- Open C:\Program Files\MSOffice\Office\XLSTART
- Remove, or delete, the file that is called GWXL97.XLA
- Close Explorer and open Microsoft Excel.
- Excel should open and run without problems.