View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jessica Jessica is offline
external usenet poster
 
Posts: 113
Default How do you lock a cell with data but still allow new data entry?

I have a spreadsheet that will be accessed by multiple users. Each user will
fill out a row of data, save and close the spreadsheet. We do not want users
to edit rows after data is entered into a row of cells. Is there any way to
lock this data to prevent it from being edited? Thanks