Object library Invalid

A

Ayo

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
 
V

Vergel Adriano

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.
 
A

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.
 

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