| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoFilter sort | Excel Discussion (Misc queries) | |||
| How do I use the autofilter to sort a list | New Users to Excel | |||
| How to Sort within AutoFilter with Protection on (and AutoFilter . | Excel Discussion (Misc queries) | |||
| autofilter sort not visible | Excel Discussion (Misc queries) | |||
| Autofilter / Sort question | Excel Programming | |||
Linear Mode
