Sorting Rows When Selected Fields are Locked/Protected

Although setting privileges when protecting a worksheet of which sorting is one, Excel doesn't allow you to sort a protected sheet.
Unless you specify the range to be sorted in the "Allow Users to Edit Ranges" window.
Unprotect the sheet. Then in the Review tab select "Allow Users to Edit Ranges" and select "New".
Then specify the range to be sorted and click "Protect Sheet"

And don't forget to allow Sorting when protecting the sheet.

Strange. Should work. I'd like to have a closer look.
Can you upload an unprotected version of the workbook or send the password in a PM?

Hi Saabra,
here's the workbook with Sort working in protected mode.
The problem was in the configuration of the data area. Excel takes the dataregion as area to sort assuming no headings or only one row of headings.
But the headings were distributed over 3 rows. And then there was the data header also confusing Excel.
I made some edits and it works fine now. The edits are reported on the sheet.

I would also recommend you convert the data area in a table. When inserting new rows the formulas will then be automatically copied to the new row.

However, I don't understand the purpose of:
1) Moving value of S55 to S53 and
2) Moving value of T54,55 to T53.

I did that to have the headers in one cell, so row 54 and 54 could be removed.
Sorting (in protected mode) needs a single header row which you can include in the range on which to allow sorting.

You may however choose to not involve the headers in any sorting.
In that case you should only specify the data range to allow sorting on.

Difference is that in the latter case you'll need to select the data range whan sorting. Also you would need to allow for selecting locked cells.

Finally I think merged cells should be avoided when possible.
When you merge cells horizontally - say D1:F1 - then the whole merged range is addressed as D1. And if merged vertically - say D1:D5 - the whole range is addressed as D1.
This may give difficulties or errors in formulas or code.

Glad I could help.
Of course you can always contact me for any further questions.
I'll keep the subscription to the thread.

....but the sorting is only being applied to columns B through E and not beyond.

I cannot reproduce this. Did you select that area prior to executing the sort?

But the range you allowed users to edit is not correct. The range should include column A as well as the header row (row 65).
If you change that it should work (it does at my end).
AllowUsersToEditRanges.JPG

In the 2nd screenshot the area B65:E81 is selected.
If you executed the sort with this area selected then only that area will be sorted. The columns to the right of that area (F:V) will keep their original order.
That's why Mr Herbert has "moved to another town" after the sort.
The fact that Mr Herbert is still 72 is because Age is calculated from the DataOfBirth which is included in the sort.
Just try the sort with only one cell selected and you will see all the columns being sorted.
Make sure you have the box "My data has headers" checked.

Hi Saabra,
I believe I replied to your post (#15) with my post #16