Thread: how do i lock a cell? to save formula or function in it?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
oteixeira oteixeira is offline
external usenet poster
  
Posts: 1
Default how do i lock a cell? to save formula or function in it?

Hi,

By default, all cells are locked when you choose
Tools/Protection/Protect Sheet or Workbook.
So you just have to go to the cells where you want the users to allow
edition and choose Format/Cells/Protection and in the protection
section untick the Locked check box. Then protect the worsheet with a
password and it's done.


--
oteixeira
------------------------------------------------------------------------
oteixeira's Profile: http://www.excelforum.com/member.php...o&userid=35320
View this thread: http://www.excelforum.com/showthread...hreadid=558089

Reply With QuoteReply With Quote