Switch off Sort with Autofilter in XL2003
 

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

Switch off Sort with Autofilter in XL2003
 

I've never seen a way.

Roger Govier wrote:

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

--

Dave Peterson

Switch off Sort with Autofilter in XL2003
 

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?

--
Regards

Roger Govier


"Dave Peterson" wrote in message
...
I've never seen a way.

Roger Govier wrote:

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

--

Dave Peterson

Switch off Sort with Autofilter in XL2003
 

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

Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
I've never seen a way.

Roger Govier wrote:

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

--

Dave Peterson

--

Dave Peterson

Switch off Sort with Autofilter in XL2003
 

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
DTHIS
www.nickhodge.co.uk


"Dave Peterson" wrote in message
...
I haven't seen xl2007. Maybe someone else can jump in.

Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
I've never seen a way.

Roger Govier wrote:

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

--

Dave Peterson

--

Dave Peterson

Switch off Sort with Autofilter in XL2003
 

Hi Nick

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

--
Regards

Roger Govier


"Nick Hodge" wrote in message
...
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
DTHIS
www.nickhodge.co.uk


"Dave Peterson" wrote in message
...
I haven't seen xl2007. Maybe someone else can jump in.

Roger Govier wrote:

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?

--
Regards

Roger Govier

"Dave Peterson" wrote in message
...
I've never seen a way.

Roger Govier wrote:

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

--

Dave Peterson

--

Dave Peterson