Excel VBA "Compile error: Can't find project or library" [but no references are MISSING]

Question

My daughter is having a problem with an Excel macro workbook that she has taken over.  She modified the spreadsheet and only the text of a button within the macro code.

A user is getting VBA "Compile error: Can't find project or library" error on the spreadsheet that works fine on my daughter's laptop.

We have checked for MISSING references but not found any on the user's pc.  The user now has the same references checked as does my daughter.

The user was and still is able to run an earlier version of the workbook.

My daughter ran into a similar issue 2 years ago and found the workaround of saving the file in an Excel 97-2003 format to enable another person to use the workbook. However, that won't work in this case because she now gets a warning about significant loss of functionality.

My daughter has Excel 2016 and the user with problems has 2010.

Any help will be greatly appreciated.

MORE INFO:

My daughter has found another PC, running an older version of Excel, which can run the previous version of the workbook but not the newer version.

Answer 1

Yes in case you're referring to external Office libraries AND are using different Office versions, late binding is the way to go indeed.

Answer 2

Not sure if this will fix your problem but have a look at it.

If you have looked for the missing references and none are missing then look in the Project Explorer (Left column of VBA editor) and compare the computers and see if any add-in project that is missing. See screen snippets below from 2 different computers.

It might not be solver but something else and if so select Options -> Add-Ins and you might need to Activate an inactive Add-in (Toolpak has 2; one for worksheet and one for VBA so if this is the missing one then select both). Select Go button at the bottom of Add-Ins screen. After checking boxes etc then ensure you click the OK buttons on the way out (don't just click cross to close) or your selections do not get saved.

Answer 3

Thank you very much!  I'll pass this on to my daughter and see what happens.

Answer 4

My daughter checked both her laptop, where things work fine, with a desktop where she gets the compile error, and both computers have no add-ins - or anything other than the items in the workbook itself.

Answer 5

Have the other user check whether his Office 2010 has all updates applied. There have been issues which were caused by an Office update and if that user doesn't have that update this is the kind of issue that occurs.