View Single Post
  #2  
Old July 11th, 2008, 12:27 AM posted to microsoft.public.excel.worksheet.functions
Pete_UK
external usenet poster
 
Posts: 8,780
Default Auto filter sort ascending not working while sheet protected

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