Thread: Protect formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mallycat
 
Posts: n/a
Default Protect formula


You can select which cells are protected and which ones are left open to
be changed.

By default, all cells are formated as 'protected'. Unprotect your
sheet, highlight the cell you want them to be able to change, Select
FORMAT\CELLS\PROTECTION and untick the locked checkbox. Then reprotect
your sheet.

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=555308