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?