No alterations till completion

[byte_me]

It is difficult to explain exactly what it is that I require, but here it goes:
Picture, if you will, a spreadsheet that requires entries from a user. The user answers questions as he/she moves down the sheet. The sheet is a test or exam. It scores the responses.
Now I want to create a sheet that will not allow the user’s responses to be changed once they have been entered as he/she works his/her way down the sheet - that is not until the test is completed and the responses are totaled. The worksheet must also be reusable for other users once the previous user has been scored.
Can somebody please suggest some coding or ideas that might help me with this?

 

[Ruddles]

You can keep the worksheet hidden so that the user can't see it and therefore can't make any manual changes to it.

Use a userform to display the questions in turn and store the answers in the hidden sheet. Each time you load the userform, select the next free row in the hidden worksheet and store the responses across this row, so you're using one row per set of responses.

You will need some VBA to achieve this.