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.

"Tushar Mehta" wrote:

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