Run Time Error

[Lorin Head]

When ever I open Excel. I get a error message - "Run Time error '5' Invaild procedure call or argument" This happens no matter how I open Excel.
Error message occures after click in another cell or after typing and tabing or pressing enter. It does this with a new book or an when an existing book is opened. After clicking on the 'end' button I don't get the message until I Open Excel again. Tried all the normal fixes that I can think of (Reboting - ReInstalling - gettting any updates) Using Excel 2000.
Thanks
Lorin

 

[Legacy 98055]

Do you have any third party add-ins installed? Is there any code in your Personal.xls file?
Tom

 

[Lorin Head]

There are no 3rd party add-ins and from what I can tell there is no 'personal.xls' file.
Thanks
Lorin

 

[XL-Dennis]

Lorin,

AS Tom says, usually this refer to some third-part add-in and personal.xls.

However, please check the XLStart-folder if there exist any files that You´re not aware of.

Check also if there are missing / broken reference.

- Open XL and push the end-button.
- Switch to VB-Editor using ALT+F11.
- Make sure that Book1.xls is selected in the Project Window.
- Select the command Tools | Reference and look for if some selected post has the name "ISMISSING". If so, unselect the reference and restart XL.

Good Luck,
Dennis

 

[Lorin Head]

Thanks for your help!
I was able to locate the add-in's and remove them...Running great now.
Thanks so much.
Lorin