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

In article ,
says...

hi there..

I'm trying to protect all cells of a sheet accept 3, I know how this
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


I could use some help..

thnx ;) ;)


--
20002238Rijk
------------------------------------------------------------------------
20002238Rijk's Profile: http://www.excelforum.com/member.php...o&userid=16320
View this thread: http://www.excelforum.com/showthread...hreadid=277108