Re: "Can't find project or library" Error
You need to remove the reference to the Calendar control from the computer that doesn't give you this reference error.
That's what I meant by inadvertently referenceing a control from that computer. The other computers obviously don't have that control / registered.
The other 2 references are the Analysis Addin. You can leave these alone as they have obviously loaded these addins.
Quote from jumper5twoDisplay More
Thanks for responding Ivan & anyone who reads this. When I try to uncheck the checked box that says missing, I get the message "Can't remove control or reference: in use". In answer to your question "What file is missing?" I don't know because the checked box only says "Missing:", nothing else.
I've found that I get this error on two office computers but it works fine on the other one (they all have Win98se and xl'97). So I compare the >reference dialog boxes. The difference (besides the "Missing:" line) is the one that works at the office and the one at home have a checked box labeled "Microsoft Calendar Control 8.0". I noted that this line is not even available to be checked on the "bad" computers. I have no idea what calendar control is used for. I do use the "Today()" function in my sheet but would that affect it?
Another big thing is that on the "bad" computers I noticed 2 projects called "atpvbaen.xls and funcres". They are not "checked" in >references and I don't know how come they are there.
I'm a bit long-winded, just wanted to help as much as possible,