Sorting Data in a Protected Sheet

[heresteve2]

Hi All,

I have a sheet with a table in it. I have some cells that are locked and others that are not. I am trying to protect the sheet but still allow the users to filter and sort the data. Excel will not allow this however because sorting would involving moving some of the protected cells.

I am 99% sure I had this working but using Allow Users t Edit Ranges, but now I can't seem to remember what I did? A

Any help here would be greatly appreciated. I don't really want to use Macros if possible.

[heresteve2]

Of course the minute I submit this thread it came back to me.

For those wondering You have to select the entire sheet go to Review - Allow Users to Edit Ranges
Click Ok and Protect Sheet and Make sure that you uncheck "Select Locked Cells"