I am using the solver function to optimize a blend of products. I want to
lock (protect) some areas of the worksheet, but when doing so the solver
function will not work and the following translated message arrives:

The active document is not a worksheet, is protected or shared.

Hope someone can help me.

Thank you.

Niels

I believe the Sover sets numeric values in the cell referenced in the "change
cell" of the solver window. Try to NOT protect this cell.
--
Basilio


"Niels" wrote:

> I am using the solver function to optimize a blend of products. I want to
> lock (protect) some areas of the worksheet, but when doing so the solver
> function will not work and the following translated message arrives:
>
> The active document is not a worksheet, is protected or shared.
>
> Hope someone can help me.
>
> Thank you.
>
> Niels
>
>