View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ripper
 
Posts: n/a
Default Lock Cell After Data Entry

Is there a way to lock a cell from edit or delete after a person has entered
data into it?

I am using Excel as a survey tool in a class. Each student will create a
survey and then the students will rotate around the lab and take each
student's survey. I don't want a student messing with the former student's
data by changing the answer. Therefore I need to lock or hide the answer
after the student entered it.
--
Thanks As Always
Rip