Hi
I'm writing an excel + VBA application that uses the
solver add in. It works fine as long as the sheet on which
the target and variable cells are, is unprotected. When I
protect the sheet the solver seems not to do anything.
There are no error messages

I use the following calls to load the model and to run the
solver:
Call Application.Run("Solver.xla!SolverLoad", "N207:N211")
Call Application.Run("Solver.xla!SolverSolve", True, False)

I use these run calls instead of the direct solver
function calls to avoid a compiler error if the reference
to the solver add-in is not set in the VB environment, but
the direct function calls seem to behave similar.

Does anyone know this problem (nothing mentioned in the MS
knowledge base)?
Is there a workaround?
Thank in advance
Regards
Jos