View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Sandie Scrivens Sandie Scrivens is offline
external usenet poster
 
Posts: 4
Default Lock formulas in a cell

Swamy

Select the cells you happy for users to work and from
Format/Cells/Protection remove the tick from Locked. Then choose
Tools/Protection/Protect sheet.

If users try to insert or delete anything in the formula cells they will not
be allowed to.