The attached spread sheet is exactly how I want it except I want the additional protection of preventing the user from accidentally changing the column titles or any of the data validation rules for the cells in each column.
So, how do I protect just the top column field titles without affecting the worksheet's current set up?
For example, when I try to lock the sheet, it affects the users ability to enter values as I want them to. I want the user to be able to copy and paste values from A-I, but for J-X, I don't want them to be able to copy and paste values as I have already coded for.
But when I try to protect the sheet, it doesn't allow me to drag values for A-I anymore.
See attached. I hope this makes sense.