Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Locking cells after one answer
I have madesome tests in excel for my students. Is there anyway of locking
cells down so that once they have entred an answer into one of the cells, it locks it in place preventing the answer from being changed |
#2
|
|||
|
|||
You could do this with a workbook_change event. right click sheet tabview
codeleft window select worksheetright window select changewrite your code. -- Don Guillett SalesAid Software "HuckinD" wrote in message ... I have madesome tests in excel for my students. Is there anyway of locking cells down so that once they have entred an answer into one of the cells, it locks it in place preventing the answer from being changed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking Cells | Excel Discussion (Misc queries) | |||
Unlocking Cells when a worksheet is protected... | Excel Discussion (Misc queries) | |||
Help me! There is problem with cells view... | Excel Discussion (Misc queries) | |||
Locking Cells | Excel Discussion (Misc queries) | |||
how can i create a formula or format the cells so the answer is a. | Excel Discussion (Misc queries) |