Oh, the cells need to be unlocked in that range to sort.

I think I'd do what was suggested in your other thread if you have to have the
cells locked.



Pete Walburn wrote:

Dave,

I'm afraid that even with no data in any adjacent cells, I get the same
problem.

I need to have the cells protected, so that the data cannot be changed, but
allow the column to be sorted.

Pete

"Dave Peterson" wrote:

Make sure that there's an empty column between the range to be sorted and any
"adjacent" data.

If you have a locked cell butting up to the range to be sorted, excel yells!



Pete Walburn wrote:

Hello,

In Excel 2003 is it possible to protect the data in a sheet, but to allow
the data to be sorted?

In the Protect Sheet command, it indicates that this facility exists, but
when I try to do a sort it won't do it until the sheet is unprotected.

Pete

--

Dave Peterson


--

Dave Peterson