View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
boatsc boatsc is offline
external usenet poster
 
Posts: 1
Default Protect Data after entry

Once data is entered into a cell I need it to be protected (automatically)
and not able to be changed or deleted.

I am using this for a auditing receivables and once I see the receivable on
the spreadsheet, I do not want anyone to be able to change or remove it.
Need to also be able to add additional receivables to spreadheet.

A formula that if a cell has data it becomes protected was my thought but ???.