View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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