"Can't find project or library" -which references are missing?

[dadel]

When trying to use a formula, I get the error message "Can't find project or library",
after I press OK, a box called "references - VBAProject" pops up, listing all avaliable references.

I can't figure out what to do next. The references are just listed, -can't see where the problem lies.
I've looked around a bit on different help forums, and usually the case with these errors is that some references are listed as 'MISSING'.
But that's not the case here.
Nothing seems to be missing. So I can't figure out what to do.

Btw: here's the formula (as in cell S2)

=IF(V2="";IF(D2="";IF(E2="AX";E2&A2;"M"&DEC2HEX(HEX2DEC(A2)+1-T2));"");"")

(Basically, if V and D are empty, it should change the value of the S2 cell, writing an 'M' followed by a hexadecimal number based on the numbers in A2 and T2 )

[DonkeyOte]

DEC2HEX and HEX2DEC both form part of the Analysis ToolPak I believe - is that activated check: Tools -> AddIns... not that it should in anyway generate that error...

[dadel]

Looks like it did though!

I took a look and saw that the "Analysis ToolPak" was activated, however the "Analysis ToolPak - VBA" was not.
I activated it, and voila! no more error messages, and everything works!

Thanks alot (you're awesome, donkeyote!)

Kind of lame though that Excel couldn't have hinted that I should check my add-ins in the error message.

[DonkeyOte]

Curious though - are you are you utilising any ATP functions from within your VBA code ?

[dadel]

Not sure (working on a project that someone else has created)

The macros seems to work without the ATP vba turned on though.