Can a cell be set to accept input only once?

S

Simple Gifts

I am trying to make a spreadsheet that can be used for student testing. It
should allow only one entry per cell so that the student cannot continue to
make guesses in the same cell.
 
D

David McRitchie

You could use a change event macro that after update
turns off protection, locks the cell, turns on protection
as long as they never look at the macros.
 
Top