Hi

When XL2003 came in, MS introduced a Sort Ascending and Sort Descending
option that appears above (All) on the dropdown when you apply
Autofilter. This is something I have never liked and always warned users
against using this to sort any data, just use the dropdown to filter
data - just like it was in XL2002.

I know that I can switch off Sort altogether, when setting Worksheet
protection, or allow Sorting by clicking the allow Sort box which sets
AllowSorting: = True

Is there any way to invoke Autofilter, whilst at the same time
preventing (and preferably not showing) Sort options from the dropdowns?

--
Regards

Roger Govier