Error running Macro/Solver result

Ok guys, my question is in two parts...

First one, when I try to run a certain macro, and I get the error saying "Compile error: Sub or Function not defined" in VB highlighting SolverOk--is this caused by NOT having referenced solver?

Second--When I try to run the same macro after I have referenced solver in that particular macro, it doesn't record the step of hitting the ok button in the solver results screen. (The screen i'm talking about is the one where it shows "solver found a solution, keep/restore etc.) I'd like to make it so that when the macro is run, the Solver Results screen isn't shown, and instead to have the macro hit OK automatically to display the results.

Thanks everyone!

Bump...this seems like a easy question for you gurus out there, all the help is appreciated, thank you!

hey...

About the first one....
you have to turn on the solver first... tools-> refernces-> solver in VB editor.

but i don't know the answer to the #2, i need it myself right now...

please HELP

i got it from other forum... enjoy

If I understand the question, one is trying to not have the result dialog
box pop up when Solver is finished.

Results = SolverSolve(UserFinish:=True)

Use "Results" to determine how solver did.

> I don't want the
> solver results box to pop up ...

HTH.
(Note that in Windows, this is backwards (in my opinion). It should be
False, because one does not want the User to interface with Solver when
done. Don't know why they changed this from the Apple version.)