commandbutton to run solver?

it wont work when i try it. I got the norwegian version of excel, and the code is the following:

ProblemløserOk Målcelle:="$B$24", MaksMinVerdi:=1, Verdi:="0", Endre:= _
"$B$18:$D$18"
ProblemløserLøs

^ this is what i recorded in the macro when i used the solver

the following gets highlighted in the code: ProblemløserOk . And the error msg says: Compile error: sub of function not defined

I get exactly the same problem (except using US english version).

The following macro code was generated using the record macro function in Excel 2003.

Please Login or Register  to view this content.

Assigning this macro to a button on the worksheet results in the following error when executed. It also generates the error when executed from the “Tools – Macro – Run” menu pull-down. It functions correctly during the recording process.

“Compile Error : Sub or Function not defined” (SolverOk is highlighted.)

Visual Basic help is pretty cryptic, and virtually no help.

Can anyone enlighten me in plain English as to what’s wrong? How do I go about “defining” the Sub or Function so the dang thing will work?

Thanks