Sort on Protected Worksheet

[pshepard]

When protecting a worksheet - selecting users will be allowed to select
protected and unprotected cells, and users will be allowed to sort.

After protecting the worksheet in this way, sort is not allowed. Is this a
bug?

---------------
Peggy Shepard

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...1de0f97&dg=microsoft.public.excel.crashesgpfs

 

[JLatham]

Probably not a bug as you might think. When you set the worksheet protection
to permit sorting, all of the cells that will be involved in the sort must be
unlocked also. Yeah, I know, I wish it worked differently also.

(P.S. I'm not MSFT employee/representative).

 

[pshepard]

Hi JLatham,

I thought that contiguous unlocked cells would automatically allow sorting
on a protected worksheet, however it isn't functioning that way.

I vote that selecting sort as an exception for protection does not require
unlocking cells; and that unlocking cells allows sort automatically on a
protected worksheet.