"can't find project or library" when opened by other Users

[Txusmah]

Hello,

I have a file that has "missing Libraries" and gives the error "can't find project or library" on the most simple functions only when opened by other users.

I have created an excel that runs several relatively simple Macros: Copypaste, print pdf and send emails.

When I run it in my computer it works well. However, when I upload it to sharepoint and other users open it (in read mode) and enable macros they get this error "can't find project or library" and the only solution is to "uncheck" the "MISSING" libraries in the references. This is not a viable solution because users do not how to use macros, and don't have to.

Why does this happen and how can I properly solve it?

thanks a lot,

 

[RoryA]

What are the missing references and are they actually used by your workbook?

 

[Txusmah]

It gives me the error when using something as simple as:

LEFT("text",2)

The missing references are "Microsoft PRoject 14.0 Object Library" and "Microsoft PRoject 14.0 Task Launch Control":

I uncheck them in the users' file and it works.

thanks a lot,

 

[RoryA]

Does the code in the workbook actually use Project? If not, just uncheck those two references and save the file.