Can't find project or library

  • Thread starter Thread starter Gerry
  • Start date Start date
G

Gerry

I keep receiving ..... Can't find project or library on the following
line.

If Left$(UCase$(response), 1) = "D" Then

This macro works fine on other computers and had been working fine
until recently. What is missing on this computer?

TIA
Gerry
 
Open excel on the troublesome pc
Open your workbook
Go into the VBE
Select your project
Tools|References
Look for MISSING reference.

Uncheck that missing reference.

The missing reference may not (usually doesn't) have anything to do with the
line that caused the error.

If you're not using that reference, you can go back to your pc and remove it and
then redistribute the workbook.

If you're using that reference, you'll have more work to do for the troublesome
pc's.
 
Open excel on the troublesome pc
Open your workbook
Go into the VBE
Select your project
Tools|References
Look for MISSING reference.

Uncheck that missing reference.  

The missing reference may not (usually doesn't) have anything to do with the
line that caused the error.

If you're not using that reference, you can go back to your pc and removeit and
then redistribute the workbook.

If you're using that reference, you'll have more work to do for the troublesome
pc's.
Click to expand...

Thanks Dave, that did the trick!!
 
Back
Top