Locking cells in columns but allow copying and adding rows

I'm having real problems with locked columns in a worksheet which have formulas in them which are constantly getting typed over accidentally by other users but still require them to be able to copy and paste a row with these locked columns in them. Specifically rows M, N, O, P.

I have the other columns unlocked without issue and these rows above locked. Fine. But what I need to allow is for someone to say, copy all of row 8 and then insert this at the bottom of my sheet with all the formulas still there and locked, but other columns be editable. It keeps coming up that the cell is protected and therefor read only which makes sense.

I've selected allow adding, deleting rows in the Protect sheet window but it still wont allow me to do this because of the locked columns. Anyone help?

Nobody have any ideas?

Can you give me a bit of guidance on how to do do the formulas in Custom Validation?

Do need to copy the formula I have already entered into the Data Validation>> Custom box when it asks for a forumla?

I've clicked on the cell, gone to data on the ribbon, click on validation, dropped down to custom and then what to I do from there? I tried pasting in the formula I used . Wrote a message to display when the cell which was click on and then copied this cell formula all down through the others in the column. This appears to be working but then how do I now lock the cells so that they can't be overwritten? and the moment they are still editable. The only way I know how to do this is to protect the sheet again which will surely still not let any other users copy and insert rows which is back to my original problem.

Ah, I did not notice this. I have change this but this still does not lock the cells. So do I then go protect the sheet from there?

Here is an example of the workbook I am using. I have used your data validation instructions in Column P only.

Example Reg.xls

Ok. When I was testing this I assumed the message would come up as soon as you attempted to type in the cell. I no realise that the message appears when you press return as it doesn't actually allow the cell to be changed.

That's it sorted then! Excellent, thank you very much

Just to reply so I can download the file.

Thanks !!! a lot!!!!