View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Protecting Formulas from deletion Protecting Formulas from deletion is offline
external usenet poster
 
Posts: 1
Default Protecting Formulas in cells

I have a fairly basic spreadsheet that my on the road sales staff fill in
weekly. It has formulas to calculate Gross Profit. However they sometimes put
in incorrect information and then clear out those cells and as they do so the
formauls go.

Is there someway of not letting them edit the cells that contain the formulas?

Cheers
Mark