View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dragons_lair dragons_lair is offline
external usenet poster
 
Posts: 13
Default Lock a formula to a column of cells

I have a running balance total but as other users access this form they
inadvertently delete the formula or add more rows than have been allowed. I
can use data protection for the form but this then creates problem if they
need to add additional rows. Is there any way I can set the formula to appear
automatically in the cell such as data validation?