Error Message

[Guest]

I am have a spreadsheed that uses macros to manipulate a matrix of text and
pictures. Until recently it was working fine. I use one matrix to
manipulate the data into the desired format. After I run this, nothing runs.
I get the message "Object library invalid or contains references to objects
that could not be found." There are no hints as to how to debug this. Any
help would be appreciated.

 

[Tom Ogilvy]

after the error, go to tools=>References in the VBE and see if you have a
reference marked as MISSING. If so, then this would be the cause of your
problem (it will need to be fixed). If not, what has changed since it was
last working.

 

[NickHK]

No code, so I'm not sure what you are trying to do or what you mean by a
"matrix of text and pictures".
However, check the References in your project for any marked "MISSING".
Also, you can use the Object Browser to check the methods/objects etc
available in the libraries that you have referenced.

NickHK

 

[Guest]

Thank you for getting back. The macro now works. I am pretty sure that all
I did between failure and working was reboot the computer. The part of the
macro that appeared to be failing was associated with CheckBoxes. Any
further thoughts would be welcome.