Hi. Solver needs to adjust cells on the worksheet.
I believe that when Solver runs, one of the first things it does is
check to make sure the worksheet in not protected. It does not have
enough logic to check if only the changing cells are unlocked.
I would suggest to unprotected the worksheet.
Or perhaps make an unprotected copy of the worksheet via vba, and run
solver on that.
= = = = =
Dana DeLouis


On 11/12/09 10:35 AM, Niels wrote:
I have made a worksheet where I am using the solver function to optimize a
blend of products. This works perfect. Now I want to lock (protect) some
areas of the worksheet, but when doing so the solver function will not work.

Following translated message arrives:
The active document is not a worksheet, is protected or shared.

Hope someone can help me.

Best ragards,

Niels