VBA - Locking a range of cells for each row based on a cell in the same row

Hi NathanA
I don't follow your point about the message
Try this code:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = True
Dim LR As Long, i As Long
LR = Range("C" & Rows.Count).End(xlUp).Row
If Intersect(Target, Range("E:G")) Is Nothing Then
    Exit Sub
End If
MsgBox "There's no need for data in this cell" & Target.Address
Me.Unprotect
For i = 1 To LR
        If Range("C" & i).Value = "Charter (lite)" Then
            Range("N" & i & ":W" & i).Locked = True
        Else
            Range("N" & i & ":W" & i).Locked = False
        End If
Next i
Me.Protect
End Sub