Sorting a protected set of cells

[ordnance1]

I want to sort a range of protected (locked) cells. When I set the
protection for the cells I clicked on the Sort option, but my cells still
will not sort. What is the point to the Sort option in the Protect Sheet
dialogbox?

 

[ryguy7272]

Unprotect sheet, sort, re-protect:
http://excel.tips.net/Pages/T002458_Sorting_Data_on_Protected_Worksheets.html
http://articles.techrepublic.com.com/5100-10878_11-5234546.html

 

[ordnance1]

I know. And that is what I did, but my question is what is the purpose of
the Sort option on the Protect Sheet dialogbox?

 

[Gord Dibben]

The purpose is...........It allows you to sort a range of contiguous
unlocked cells on a sheet.

Unlock A1:F30

Protect sheet with allow sort enabled.

Select A1:F30 or any range with A1:F30 and you can sort that range

Select A1:G30 or A131 and be denied.


Gord Dibben MS Excel MVP