Thanks for looking at this.

I pasted the code, however, none of the cells in N:W were locked even if 'Charter (lite)' was in the same row. I could still click on the cells and type in them.
If it makes a difference, 'Charter (lite)' is selected from a dropdown list rather than written in as a value.

Also, what does the line "If Intersect(Target, Range("E:G")) Is Nothing Then" do as E:G is not something the code focuses on?