Solver.xla was missing. I don't know why. I use solver in other code for
another sheet, but it doesn't work anymore (I guess b/c solver.xla is
missing).

Why would missing solver.xla have anything to do with "Format"? or is it
just saying, in general, that something is wrong, not necessarily with
"Format"?

Also, how could I be missing solver.xla when I use it fairly often in this
file? How do I enable it other than re-inserting the disk (I guess I could
dig it up somewhere)?

Thanks, Mike Allen

"Norman Jones" wrote in message
...
Hi Mike,

In the VBE, with the problematic workbook's project selected, go to:
Tools | References
and look for any entries marked 'Missing'.

Uncheck these if they are not needed or use the browse button to locate
the reference.


---
Regards,
Norman



"mike allen" wrote in message
...
I have a function that works fine in a workbook by itself, but when I
attempt to add that function to another workbook (simply combining 2 into
1), I get an error message:

"Compile Error Can't find project or library."

then it highlights in yellow the entire function line and highlights in
blue "Format" in the line:

maturitymonth = CInt(Format(maturity, "mm"))

The odd thing is it works fine when by itself. It only does this when I
add this function into a large workbook with other functions and subs and
worksheets. Any ideas? thanks, mike allen