Hi, I want cell C to F of each row to lock if cell B value = "Completed"
I currently got it to work for 1 row only but I want this to repeat for every row.
The code I have so far
Thank you in advance everyone!
Private Sub Worksheet_Change(ByVal Target As Range)
'Lock Cell after verified
If [B1] = "Completed" Then
ActiveSheet.Unprotect ("PASSWORD")
[C1:F1].Locked = True
ActiveSheet.Protect ("PASSWORD")
'Remove locked property if B3's value is anything else or is deleted.
Else
ActiveSheet.Unprotect ("PASSWORD")
[C1:F1].Locked = False
'Optional, reprotect sheet
ActiveSheet.Protect ("PASSWORD")
End If
End Sub