Do it for "n" cells
Hi Joel
I got it working!
Have a look on it:
Private Sub Worksheet_Change(ByVal Target As Range)
n = Target.Cells.Row
If Range("E" & n).Value = "A Then
ActiveSheet.Unprotect ("")
ActiveSheet.Range("G" & n & ":K" & n).Locked = True
ActiveSheet.Range("F" & n).Locked = False
ActiveSheet.Protect ("")
Else
ActiveSheet.Unprotect ("")
ActiveSheet.Range("G" & n & ":K" & n).Locked = False
ActiveSheet.Range("F" & n).Locked = True
ActiveSheet.Protect ("")
End If
End Sub
Thank you anyway!
|