Does anyone know what this message is?
"Object library invalid or contains references to object definitions that
could not be found"

I was trying to run a macro that I have just finished writing and now I
can't run it anymore because I keep getting this message. And when I click on
the help button, it is blank. So I can't fix the problem and I don't know
what the problem is.
If anyone out there know what is going on, please help.

Thank you.
Ayo

I googled the error message and found this link:

http://www.ozgrid.com/forum/showthread.php?t=28423

The last post in the thread seem to be the right answer. Here's an exerpt:

In the end, today I just figured what I'd done to cause this:

The name I had given for a button on the excell sheet was identical to the
name I had carelessly given to the sub that gets called when you press that
button.

In other words, in the sub "RemoveClient_Click()" I called a sub named
RemoveClient.... so there was a sub and a button with identical names.




--
Hope that helps.

Vergel Adriano


"Ayo" wrote:

Does anyone know what this message is?
"Object library invalid or contains references to object definitions that
could not be found"

I was trying to run a macro that I have just finished writing and now I
can't run it anymore because I keep getting this message. And when I click on
the help button, it is blank. So I can't fix the problem and I don't know
what the problem is.
If anyone out there know what is going on, please help.

Thank you.
Ayo

Although I have never had this error, from what I have read it is something
to do with the cached interface definition getting out sync with that in the
current code.
You could try Rob's Code Cleaner:
http://www.dailydoseofexcel.com/arch...er-version-50/

It may be worth closing all apps and cleaning out your Temp folder also.

NickHK

"Ayo" wrote in message
...
Does anyone know what this message is?
"Object library invalid or contains references to object definitions that
could not be found"

I was trying to run a macro that I have just finished writing and now I
can't run it anymore because I keep getting this message. And when I click
on
the help button, it is blank. So I can't fix the problem and I don't know
what the problem is.
If anyone out there know what is going on, please help.

Thank you.
Ayo

Thanks guys,
I think I found the problem. I was using this line of code:
"Private Sub cmdGenReport()" instead of this:
"Private Sub cmdGenReport_Click()", for a button on one of my worksheet.
Thanks again for all your help.

"NickHK" wrote:

Although I have never had this error, from what I have read it is something
to do with the cached interface definition getting out sync with that in the
current code.
You could try Rob's Code Cleaner:
http://www.dailydoseofexcel.com/arch...er-version-50/

It may be worth closing all apps and cleaning out your Temp folder also.

NickHK

"Ayo" wrote in message
...
Does anyone know what this message is?
"Object library invalid or contains references to object definitions that
could not be found"

I was trying to run a macro that I have just finished writing and now I
can't run it anymore because I keep getting this message. And when I click
on
the help button, it is blank. So I can't fix the problem and I don't know
what the problem is.
If anyone out there know what is going on, please help.

Thank you.
Ayo