I am currently using XL2000 and would have solved your problem with a macro
that unprotects the sheet, then do the sorting and finally protects the sheet
again.
--
Regards,

Martin


"Sue" wrote:

By the way it is excel 2003 I'm working with.

"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.