Sort Table on Protected Sheet

[gberg]

I am looking for a way to sort a table on a protected sheet.
The table I have has 16 columns. Four of the columns are "Unlocked" so they can be edited, the other twelve columns are locked.

I protected the sheet with these options:

I can filter the items, but cannot sort them.

I tried to "Allow Edit Ranges" and selected the table but it still gives an error when trying to sort.

Is there any way to sort a table on a protected worksheet?

Tahnks,

 

[Michael M]

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

 

[gberg]

That was my last resort. Not sure how people will want to sort so wanted to give them the option. Guess i will need to go with a few options and have macros for those if there is no way to make it work.

 

[Michael M]

I guess thats why we have sheet protection.....so others can't do that sort of stuff....