View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default protect cells in excel to prevent users from deleting formulae

You can lock or unlock each cell via:
format|cells|protection tab

But the "lockedness" of the cell doesn't mean much until you protect the sheet.
Tools|protection|protect sheet

Be aware that worksheet protection is easily bypassed and there are lots of
things that aren't available on protected sheets.

locking cells in excel wrote:

how do i protect cells in excel to prevent users from deleting formulae in my
worksheets


--

Dave Peterson