How To Lock Cells
 

I was just wondering how can i lock cells so a formula cannot be eddited
or how do i lock cells so any of the information cannot be edited as
well.

Please and thanks


--
Ziggy M
------------------------------------------------------------------------
Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338
View this thread: http://www.excelforum.com/showthread...hreadid=573038

How To Lock Cells
 

Got It..

Thanks


--
Ziggy M
------------------------------------------------------------------------
Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338
View this thread: http://www.excelforum.com/showthread...hreadid=573038

How To Lock Cells
 

format|cells|protection tab|check locked

But this works in conjunction with:
tools|protection|protect sheet

(and this protection is easily broken.)

Ziggy M wrote:

I was just wondering how can i lock cells so a formula cannot be eddited
or how do i lock cells so any of the information cannot be edited as
well.

Please and thanks

--
Ziggy M
------------------------------------------------------------------------
Ziggy M's Profile: http://www.excelforum.com/member.php...o&userid=36338
View this thread: http://www.excelforum.com/showthread...hreadid=573038

--

Dave Peterson

How To Lock Cells
 

Just highlight the cell(s) you wish to lock, then right click on those cells
and go to Format Cells. From there, go to the "Protection" tab. You can
choose how you want to protect the cell. Once you have finished that, you
must then protect the entire sheet - go to Tools Protection Protect Sheet.

That should do it =)