Protecting a sheet that includes a solver function

  • Thread starter Thread starter 20002238Rijk
  • Start date Start date
2

20002238Rijk

hi there..

I'm trying to protect all cells of a sheet accept 3, I know how thi
works but the sheet contains a "Solver" wich can be run using a macro
after protecting the sheet the solver doesn't seem to work anymore
:confused: :confused:

I could use some help..

thnx ;) ;
 
As you have discovered Solver needs the worksheet to be unprotected.

If you must run Solver using cells from this particular worksheet
unprotect it first.

Or, use Solver on another worksheet that is always unprotected.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Tushar,

I am not responding to your question, but I have question which I think you
can help.

I am unable to run macros which include solver function! You seem to have
done just that. Please help.
 
Hoping that you can help me with my problem.

I am unable to run solver with a macro.

Solver runs fine when I run it manually without using macro.

Any suggestions?

Error message I get is "Sub or Function not defined".
 
Back
Top