Recording and playing Macro (Solver)

[Idoia]

Hi,

I've recorded a macro that consists on using solver on a target cell. The
code I get is very straightforward:

SolverOk SetCell:="$N$39", MaxMinVal:=2, ValueOf:="0",
ByChange:="$B$61:$B$64"
SolverSolve

When I try to replay the macro, I get the compile error "Sub or Function
not defined" (with "SolverOk" highlighted)

I suspect it has to do with the fact that solver is an add-in, but if it's
able to record it, it should be able to replay it, right?

Any halp would be appreciated. Thanks!

 

[Gary''s Student]

From VBE:

Tools > References > check SOLVER

 

[Idoia]

That worked, thanks a lot.

 

[Mike]

I've exactly the same problem plus one more: the Reference command under Tool
is dim and cannot be activated?