rivate Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = Range(Cells(Target.Row, "BG"), Cells(Target.Row, "EL"))
If Not Intersect(rng, Target) Is Nothing Then
If Application.Sum(rng) = 84 Then
Me.Unprotect
Target.Offset(, 1).Resize(, 7).Locked = True
Me.Protect
End If
End If
End Sub