If any of the cells  in the range to be sorted/filtered are locked, you can't
sort or filter them with sheet  protection on, in spite of setting AllowSorting
and AllowFiltering to TRUE. You could unlock all the cells in the range to be
sorted/filtered, or you could use macros to unprotect the sheet, sort  a
particular column, and re-protect the sheet.