Can I use solver functions in a protected (locked) worksheet?
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
|