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

TWO STEPS

Format Cells Protection
Tick 'locked' for the cells you want to be protected
untick it for any cells you don't want protected

Then
Tools Protection Protect Sheet
Allow users to select only unlocked cells
Put a password in

--
Allllen


"locking cells in excel" wrote:

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