Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Write once cells
Is there any way that I can write a macro or code for a quiz sheet I have made. I want my pupils to be able to type into the cell but would like it lock the cell after they have typed something in so effectively I can use it as a test but the first answer is the one that counts. Somebody suggested that I rightclick on the workbook tab and then use the view code function, but I know nothing about computer code and would not know what to write in the boxes Any ideas would be greatly appreciated. Thanks Dave -- HuckinD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
How do you write 2 lines of text in 1 cell rather than use 2 cells | Excel Discussion (Misc queries) | |||
Using SUM function with #N/A in some cells | Excel Worksheet Functions | |||
Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions |