Help Required with strange error message?

  • Thread starter Thread starter Alan T
  • Start date Start date
A

Alan T

When trying to edit a macro I recorded I am returned with the followin
message:-

Compile Error:
Can't find project or library

In the macro code "response" is highlighted, and when I search in th
object browser it is no longer listed as an option there.

It was there when I wrote the macro, but to the best of my knowledg
no-one has changed any of the settings on the workstation.

Any suggestions on what has happened, and how I get it back?
 
Just some guesses.

Inside the VBE for that project, try Tools|References and look for something
marked Missing.

If you don't find anything, maybe you can re-register excel.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.
 

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

Similar Threads

VBA errors in 2007 (works fine in 2003) 14
setlanguagestrings message upon opening excel 1
Can't find project of library 3
Word VBA to update cross-referencing 0
Macro Help Requires 5
Excel 2003 accepting error message in macro 2
VBA Error Message "Compile Error...." 3
Compiler Error 4

Back
Top