I'm currently working on a medical research project where large amounts of data is about to be registered in several worksheets. Now, I won't be registering the data myself (I got someone to do that for me), but I want to reduce the risk of input error.
So far, I have locked the first column and row (Fixed patient ID on first column and variable names on first row), and I have set up data validation ranges for all input cells. When I protect the sheet (password protected), everything seems ok. I can then only input values specified through data validation and input is forbidden in the first row/column.
But...when all the values of a row (patient) is put in, is there any way of locking that row without going through the unprotect-lock-protect process?
I would like my workers to be able to input data in a protected sheet. But as soon as the data of a row is verified I need them to be able to add those cells to the protected range. I don't want them to be able to unprotect anything in the worksheet, but I want them to be able to protect the values of certain cells. Is this doable? Any help i very much appreciated.
Bookmarks