According to the MS Excel help text entitled "Overview of security and
protection in Excel" if on the Protect panel I check the Sort checkbox then
users are supposed to be able to sort data on the worksheet. If I can only
sort unlocked cells, then the feature is out of step with the documentation;
it's also next to useless, since it means that on a form where rows contain
both locked and unlocked cells I am not able to allow users to sort anything
(since that would involve sorting locked cells).

I stand by my original statement: MS needs to fix this feature so that it
works like the documentation says it works.

Thanks for trying to help.

Regards,
Christopher

"Peo Sjoblom" wrote:

It works, you have to unlock the cells in question before you protect it
under formatcellsprotection,
select the ranges you want to sort and uncheck locked, then protect the
sheet with these options

--
Regards,

Peo Sjoblom

Portland, Oregon




"Christopher Rath" <Christopher wrote in
message ...
When setting Excel Protection, the options include allowing sorting,
allowing
deleting of rows, etc. In my experience with Excel 2003, these options do
NOT work as advertised: even though I have ticked those options Excel
still
forces me to remove protection before sorting protected cells or deleting
rows in a protected sheet.

----------------
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/comm...lic.excel.misc