Forum Discussion
How to freeze values in a cell when another cell contains "Yes"
I can think of a solution with "radio buttons" in "group boxes". You'll find them in the DEVELOPER ribbon, but it requires quite a bit of design to make it look nice. And, depending on your target group (how smart are they with Excel?) it could take quite some effort to make it "fool"-proof.
The attached workbook is a very quick and dirty example. It contains two questions with yes/no buttons. The first sheet and the entire workbook, including a hidden sheet called "Result" are protected. Unprotect everything first (no passwords needed in this example) to see what I'm trying to do (Tools, Protection, ......) and unhide the Results tab (Format, Sheet, Unhide .......)
There is a small macro included that copies the FinalScore to the first sheet and it replaces the calculated score on the Result tab with the word "FAIL". If the button is pressed more than once, FAIL comes up as the Score in the first sheet and you may suspect that your student tried to cheat. Or perhaps he/she accidentally pressed more than once without the intention to cheat. Who knows? That's where a lot of extra work comes if you want to make the system more secure. Up to you to decide how "secure" this system has to be and to decide if this approach could works in your situation.