You have to unlock ALL the cells which will be sorted. Then protect the
sheet. In the Protect Sheet dialog, make sure Select Unlocked Cells, and Sort
have checkmarks. If Select Locked Cells is checked, uesrs can select those
cells but not change them. They will be able to sort (and change) the
unlocked cells.

Hope this helps,

Hutch

"J9" wrote:

I need to protect a worksheet and still have the user be able to sort data by
column. I have tried using the "Unlock" feature in the Format
Cells--Protection dialog box but it doesn't make a difference. Once you
protect, you can't sort. Ideas?