Can a cell be set to accept input only once?

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.

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.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Simple Gifts" <Simple [email protected]> wrote in message news:[email protected]...
> 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.