I am using Excel 2003. After locking the cells with the formulas in them I go
to Protect Sheet and it gives me a bunch of check boxes for the things I want
to allow users of the worksheet to do. One of them is sort. I check that box
and then apply protection. However, when I go back to AutoFilter from the
column header and click "sort ascending" it will not allow me to. It says "
the worksheet is protected and cannot perform the change you are requesting".

Anything else I could be missing here?

Thanks for all of your help.
--
TommyB


"Pete_UK" wrote:

If you have Excel 2000 (and maybe 2002 - I'm not sure exactly when it
was changed) then you will not be able to sort on a sheet which is
protected. Later versions did allow certain options when the sheet was
protected, but I'm not sure if those extended to sorting.

Pete

On Jul 10, 11:20 pm, TommyB wrote:
I have a sheet with a couple of columns that contain formulas, so I have
protected those columns and left the rest of the sheet open for data entry.
The problem is, now when I try to sort ascending or descending (on a column
containing dates) using the auto filter, it just does not work at all.

Any suggestions?
--
TommyB