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?

Unprotect sheet, sort, re-protect:
http://excel.tips.net/Pages/T002458_...orksheets.html
http://articles.techrepublic.com.com...1-5234546.html


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ordnance1" wrote:

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?

.

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?

"ryguy7272" wrote in message
...
Unprotect sheet, sort, re-protect:
http://excel.tips.net/Pages/T002458_...orksheets.html
http://articles.techrepublic.com.com...1-5234546.html


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ordnance1" wrote:

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?

.

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 A1:D31 and be denied.


Gord Dibben MS Excel MVP

On Thu, 24 Dec 2009 09:04:14 -0800, "ordnance1"
wrote:

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?

"ryguy7272" wrote in message
...
Unprotect sheet, sort, re-protect:
http://excel.tips.net/Pages/T002458_...orksheets.html
http://articles.techrepublic.com.com...1-5234546.html


--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"ordnance1" wrote:

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?

.