Locking cells after one answer

[Guest]

I have madesome tests in excel for my students. Is there anyway of locking
cells down so that once they have entred an answer into one of the cells, it
locks it in place preventing the answer from being changed

 

[Don Guillett]

You could do this with a workbook_change event. right click sheet tab>view
code>left window select worksheet>right window select change>write your
code.