Switch off Sort with Autofilter in XL2003

  • Thread starter Thread starter Roger Govier
  • Start date Start date
R

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?
 
I've never seen a way.

Roger said:
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?
Click to expand...
 
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?
 
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
 
Hi Nick

Thanks for confirming the worst!!!
Only colour is spelt wrong ;-))
Click to expand...
Now why doesn't that surprise me??

--
Regards

Roger Govier


Nick Hodge said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 macro for turning on AtoZ autofiltering on a protected 5
VB macro ascending & decending Alpha sorting on protected sheet 4
Utilizng full AutoFilter features while specific cells are protect 3
Copying nothing/everything when an autofilter returns no results? XL2003 1
Enabling Autofilter and Sorting in a Protected Sheet 2
removing autofilter sort options 4
AutoFilter selected row not 'retained' across user unselect/select 3
sort dynamic range on active cell 3

Back
Top