ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Visual Basic Error (https://www.excelbanter.com/excel-discussion-misc-queries/93029-excel-visual-basic-error.html)

cmar

Excel Visual Basic Error
 
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



JLatham

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

"cmar" wrote:

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




Chip Pearson

Excel Visual Basic Error
 
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


"cmar" wrote in message
...
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





All times are GMT +1. The time now is 01:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com