Excel 2000 runtime error 1004...

K

Karen

I am getting a runtime 1004 error - method 'OnKey' of
object_Application failed. This happens everytime I open
excel. I have to hit the enter key about 15 times before
excel will open and I can use it.

Any help appreciated!!!

Thanks...Karen
 
R

Rob Bovey

Karen said:
I am getting a runtime 1004 error - method 'OnKey' of
object_Application failed. This happens everytime I open
excel. I have to hit the enter key about 15 times before
excel will open and I can use it.

Hi Karen,

This problem is most likely being caused by a malfunctioning Excel
program that is being loaded when Excel starts up. There are two places
where program workbooks could potentially be running from. Here's how to
find them and get rid of them:

1) Once you have Excel open, select Tools/Add-ins from the Excel menu.

2) In the Add-Ins dialog, uncheck every add-in that has a checkmark beside
it, make note of the names of the add-ins you uncheck, then click OK.

3) Close Excel, then using Windows Explorer, navigate to your XLStart
directory. If you installed Office to its default location, this will be:

C:\Program Files\Microsoft Office\Office\XLStart

If you're running Windows 2000 or XP, there's an additional start directory
you need to check located at:

C:\Documents and Settings\<username>\Application
Data\Microsoft\Excel\XLSTART

Where <username> is the username you're logged in as.

4) If there are any files in the XLStart directory, move them another
location temporarily (don't rename them and leave them there, it won't
work).

Once you've done all this, restart Excel and the problem should be gone.
To determine exactly which program file was causing the problem, add them
back one at a time, restarting Excel each time until you get the error
again. When that occurs, whichever one you added last is the culprit.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *
 
K

Karen

-----Original Message-----


Hi Karen,

This problem is most likely being caused by a malfunctioning Excel
program that is being loaded when Excel starts up. There are two places
where program workbooks could potentially be running from. Here's how to
find them and get rid of them:

1) Once you have Excel open, select Tools/Add-ins from the Excel menu.

2) In the Add-Ins dialog, uncheck every add-in that has a checkmark beside
it, make note of the names of the add-ins you uncheck, then click OK.

3) Close Excel, then using Windows Explorer, navigate to your XLStart
directory. If you installed Office to its default location, this will be:

C:\Program Files\Microsoft Office\Office\XLStart

If you're running Windows 2000 or XP, there's an additional start directory
you need to check located at:

C:\Documents and Settings\<username>\Application
Data\Microsoft\Excel\XLSTART

Where <username> is the username you're logged in as.

4) If there are any files in the XLStart directory, move them another
location temporarily (don't rename them and leave them there, it won't
work).

Once you've done all this, restart Excel and the problem should be gone.
To determine exactly which program file was causing the problem, add them
back one at a time, restarting Excel each time until you get the error
again. When that occurs, whichever one you added last is the culprit.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


.
 
K

Karen

Thanks Rob!! it worked :)
-----Original Message-----


Hi Karen,

This problem is most likely being caused by a malfunctioning Excel
program that is being loaded when Excel starts up. There are two places
where program workbooks could potentially be running from. Here's how to
find them and get rid of them:

1) Once you have Excel open, select Tools/Add-ins from the Excel menu.

2) In the Add-Ins dialog, uncheck every add-in that has a checkmark beside
it, make note of the names of the add-ins you uncheck, then click OK.

3) Close Excel, then using Windows Explorer, navigate to your XLStart
directory. If you installed Office to its default location, this will be:

C:\Program Files\Microsoft Office\Office\XLStart

If you're running Windows 2000 or XP, there's an additional start directory
you need to check located at:

C:\Documents and Settings\<username>\Application
Data\Microsoft\Excel\XLSTART

Where <username> is the username you're logged in as.

4) If there are any files in the XLStart directory, move them another
location temporarily (don't rename them and leave them there, it won't
work).

Once you've done all this, restart Excel and the problem should be gone.
To determine exactly which program file was causing the problem, add them
back one at a time, restarting Excel each time until you get the error
again. When that occurs, whichever one you added last is the culprit.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top