Protected Worksheet

[GMC The Macro Man]

Hi there,
I have a spreadsheet that allows users to enter data in multiple rows and columns and I have some cells with the sheet to do some calculations for the user so I have both "Locked & Hidden" these cells so the users cannot access them (delete).
The problem I have is that the user may want to add a new row of data at the bottom of the sheet and then DATA sort it to run in alpha / numerical order but because I have some cells locked and the sheet protected, then the SORT & FILTER function does not work. I need to filter on 2 columns so that is why i need the DATA SORT function to work.
Can anyone advise what my best option would be here
Thanks as always
George

 

[GMC The Macro Man]

I found this answer from a previous post, its not what I was wanting but it will do the task. Thanks to Michael M. for the solution

Record a macro to UNPROTECT the sheet first, sort the data, then REPROTECT the sheet.