Hi, I currently have a protected sheet with a range of unprotected cells which allows users to input data. The sheet currently does not allow users to click on a cell that is not in the range however the user can still jump around the drop lists or select a blank cell in the range if they choose. I would like to make it that only the next cell unlocks and the previous ones can be selected if they so choose. by either clicking or the left arrow or up arrow keys and only allow a user to use the right and down arrow key as far as the unanswered drop list. The cells currently automatically jump to the next required cell once an answer is chosen. Example

if A1="" Lock All Cells other than A1
else A3 uprotect

if a3 ="" lock all cells other than A1,A3
else A5 unprotect

If A5 = "" lock all cells other than A1,A3,A5
else C1 unprotect

if the user can select an answer from C1 they can also select the previous cells A1,A3,A5 by clicking or toggle up/down left/right between cell range a1,a3,a5,c1

Hope this is clear enough current code to lock cells is 

Please Login or Register  to view this content.
I've just used if statements and range.select to move to next droplist