Protecting a sheet that includes a solver function
 

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
:confused: :confused:

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

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
:confused: :confused:

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

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
:confused: :confused:

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

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".

"20002238Rijk" wrote:


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
:confused: :confused:

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