I have a spreadsheet for data entry that will be posted to the web for people
to download and fill in information at their convenience, but I want to make
sure that when they send the data back to me they input their name on the
sheet in a cell designated for their name.

Is there a way I can force them to enter a name into a cell on the sheet? I
can place validation on the cell, but it will not actually kick in until they
enter that cell to edit data in it. Is there a way I can force them into
that cell and not allow them to continue or back out without putting their
name in?