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 |
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 |
All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com