if u r using office 2003, there is a way out there.

before protecting the sheet, kindly select the "sort" button there at the
time of giving password first time (protect sheet title)

click yes, if it works

"dave" wrote:

Is there a way to sort locked cells in a protected worksheet so that a user
can sort cells but cannot input data in certain cells?