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

I'd like to lock a range of cells (N:W) if the value in cell C of the same row is "Charter" (and this value is chosen from a drop-down list). I'd like to write the code so that this happens for every row.

For example, if C10 = "Charter", N10:W10 would be locked, and if C14 = "Charter", N14:W14 would be locked.
However, if the value in C equals anything other than "Charter", the cells N:W of the corresponding row would be unlocked.

I'd also like to change the default message with a custom message, but I can't figure out how to focus the message on the would be locked cells.

I've attached the code below. Any guidance would be much appreciated.

Please Login or Register  to view this content.

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?

Thanks for your reply. Say cell C2 contains "Charter (lite)" and I click on N2, the code works and the error message comes up. However, after clicking Ok, the whole sheet (every cell) becomes protected and the sheet needs to be unprotected in the Info menu. Is there a way to stop that from happening?

Perfect, thanks so much!