Switch off Sort with Autofilter in XL2003

[Roger Govier]

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?

 

[Dave Peterson]

I've never seen a way.

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?

 

[Roger Govier]

Thanks Dave

I haven't either, but just hoped that someone would know a little tweak
that would get rid of the pesky thing.
I much prefer Autofilter in XL2002 (that's the only thing I prefer
though!!)

Do you know if XL2007 behaves the same?

 

[Dave Peterson]

I haven't seen xl2007. Maybe someone else can jump in.

 

[Nick Hodge]

Roger/Dave

Bad news I'm afraid (for Roger anyhow), not only does it have sort (Highest
to Lowest and Lowest to Highest). It also has 'by colour' (Only colour is
spelt wrong ;-))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk

 

[Roger Govier]

Hi Nick

Thanks for confirming the worst!!!

Only colour is spelt wrong ;-))

Now why doesn't that surprise me??

--
Regards

Roger Govier

Roger/Dave

Bad news I'm afraid (for Roger anyhow), not only does it have sort
(Highest to Lowest and Lowest to Highest). It also has 'by colour'
(Only colour is spelt wrong ;-))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
www.nickhodge.co.uk