If you're careful and only select the cells to sort--and all those cells in the
selection are unlocked, then you should be able to sort the data (with allow
users to sort checked).

But my bet is you want to sort some cells that are locked on that protected
sheet.

Maybe you could provide a macro (or two) that would unprotect the worksheet,
sort the data, and then reprotect the worksheet.

If you record a macro when you do it and need help modifying it, post back.

Sue wrote:

I have a workbook that has some cells locked/hidden and the worksheets
protected, because I don't want my formula's messed with. However there are
other cells where a user (not me) will input data and need to sort it into
alpha or date of birth order, but they can't due to the sheet being
protected. The unlocked cells box has been checked of course in the
tools/protection window before passwording and I have checked the sorting box
as well so... why won't it let it be sorted. It comes up with sheet is
protected, read only, need to remove protection to get it to sort. But if I
remove the protection I run the risk of someone deleting my formula's. Can
anyone help? Why is there a selection of boxes to check what you want to
allow to have happen once protected, if you can't do it. I know the unlocked
cells one works once the sheet is protected so why not sort? What am I doing
wrong? The only thing I do is the template, no data imputing and due to the
user's level of competency it is too risky to leave formula's exposed. It is
not a shared workbook by the way.

--

Dave Peterson