Excel Visual Basic Error

C

cmar

Whenever I try to enter a formula in cell, I get this MS Visual Basic
warning:
" Can't find project or library."

After I click "OK", I can enter the formula in the cell. How can I get rid
of this message?
Thanks, CMA
 
J

JLatham

Is it one particular formula or all formulas? Could you post an example of a
formula that gives you this error please?
 
C

Chip Pearson

In VBA, go to the Tools menu and choose References. See if any
are marked MISSING. If so, and you don't need that reference,
uncheck it. If you do need it, you'll need to Browse to find the
correct file.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top