• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Auto lock cells if other cell have certain data !

N

napadalia

New Member
Hi,


New to this website !


I have this shared spreadsheet where everyone logs data in column A to D an I have to confirm with yes/no in column E if the task logged in those cells is completed or not.


Problem i currently have is others keep changing the data in cell A:D after the task is completed which results in difference in completed tasks.


I normally lock the cells A:D of that row once the task is done, but I was wondering if thereis any VBA formulas where if i change cell E1 to yes from no it locks cell A1:D1 and same in following rows like if cell E2 is changed to yes it locks A2:D2 and so on.....
 
Welcome!


Can you use Data Validation?

Select A2:D2, Data Validation, custom formula:

=E2<>"Yes"


That way once there is a Yes in E2, the user can't type anything new into A2:D2 (note: they could paste into the cell...is that a common occurence for these cells?)
 
You must log in or register to reply here.
Back
Top