Can't find project or library

[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

 

[Dave Peterson]

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.

 

[ryguy7272]

Take a look at this:
http://www.cpearson.com/excel/References.htm

HTH,
Ryan---

 

[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 removeit and
then redistribute the workbook.

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

Thanks Dave, that did the trick!!