I am getting an error saying "Can't find project or library" error message when I try to run a VBA project. I am trying to go into the References to see if there is something there that is causing an issue, but when I click on it, it does nothing.
Any suggestions?
Add A Reference Make sure that you click on the workbook you want to add the reference to, and from the VBA editor menu choose Tools -> References. In the displayed list check the box beside your renamed add-in, and then click on OK. You'll see that your workbook now has a new reference to the add-in.
From the Tools menu, choose References to display the References dialog box. The References dialog box shows all object libraries registered with the operating system. Scroll through the list for the application whose object library you want to reference.
First, you should try the Detect And Repair option on the Help menu. After this has run, close Excel and reopen it and look at the References dialog in VBA. If there are no missing references, then Detect And Repair worked successfully.
On the Tools menu, click References to display the References dialog box. You see that Refme.
This worked for me - a. Copy/paste the problematic file to a new location. The error seems to be resolved in the file in the new location. b. Delete the problematic file in the original location (optional) c. Copy/paste the corrected file back to the original location.(optional)
I also managet to fix it by disabling all macros, saving the file, and then enabling them from the "Macro Security" in the Developer tab.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With