Can I use solver functions in a protected (locked) worksheet?

N

Niels

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can I use solver function in a locked (protected) worksheet 1
Using solver function in a locked (protected) worksheet 2
Solver Compiler issue 2
Solver gotchas 2
Solver won't open 1
Accessing the Solver Add-in in VBA 1
How do I use Excel Solver (for an Iteration in a row) for several no.of times? 0
Setting up Solver reference in a protected VBA project 1

Top