Allow sort of table with locked cells. Is this possble?

[Glen M]

I searched the previous questions but found no answer.

I have a table and in that table I have some columns that I would like to lock. My users enter data from a user-form. When the form is open the sheet is unprotected, when the user exits the form I want to lock certain columns so the user can't enter data in them manually ( they contain formulas). I can lock the cells no problem and everything is working well EXCEPT - when the user tries to sort the data in the table it wont let them because of the locked cells. I tried the "allow edit range" no dice. I have the correct protections selected in the protect sheet options. Is what I want to do possible?

I am open to any ideas. I thought maybe I could put the formulas in a second table (maybe even on a hidden sheet) and link back to my main table so I could lock the second table but leave the main table open. I don't know just brainstorming ideas so my user can sort but I keep the formulas safe.

Thanks for any help. If its not possible I guess the user will win and have to be careful not to enter data in those cells.

 

[Fluff]

Unfortunately you cannot sort data on a protected if any of the cells are locked.