You have to activate a Solver reference. In the VBA window, go in
Tools>References...
There you'll have to browse the solver.xla
it usually is in C:\Program Files\Microsoft Office\OFFICE11\Library\SOLVER
> When a macro is recorded and the Solver is executed the command "SolverON"
> cannot be interpreted and the Macro execution stops at this command.
[quoted text clipped - 7 lines]
>
> http://www.microsoft.com/office/community/en-us/default.mspx?mid=e4e478ba-aa7c-4
2c5-b9a1-b1b3f35e139a&dg=microsoft.public.excel.crashesgpfs