hi
how do i get the show all button to appear in the task bar
thanks

Hi Derwood,

What are you calling the show all button?
What are you calling the Task bar? (the Taskbar is the windows bar at the
bottom of the screen with the start button, system tray and any
open windows in it.)

Regards
Martin

sorry yes the show all command that allows all the data to be shown
when filtered after i have looked at specific range
to be shown in the top of the screen. thanks....

On Jan 28, 7:06 pm, "MartinW" wrote:
Hi Derwood,

What are you calling the show all button?
What are you calling the Task bar? (the Taskbar is the windows bar at the
bottom of the screen with the start button, system tray and any
open windows in it.)

Regards
Martin

Not aware this is one - up to Excel 200 anyway.

Simple Macro as below will work though

Sub Filter_Back_to_All()
'
Selection.AutoFilter Field:=1
Selection.AutoFilter Field:=2
Selection.AutoFilter Field:=3
'
' repeat the above for each column that you may have
End Sub

Steve

On Sun, 28 Jan 2007 11:24:08 -0000, Derwood wrote:

sorry yes the show all command that allows all the data to be shown
when filtered after i have looked at specific range
to be shown in the top of the screen. thanks....

On Jan 28, 7:06 pm, "MartinW" wrote:
Hi Derwood,

What are you calling the show all button?
What are you calling the Task bar? (the Taskbar is the windows bar at
the
bottom of the screen with the start button, system tray and any
open windows in it.)

Regards
Martin

Yeah I'm still a bit confused here too.
Are you just trying to turn autofilter off?
If so go to DataFilter and click on autofilter again.

HTH
Martin

I assumed, that a select/range had been applied to one or more of the
filters
and a quick way back to "Shwoing All" was required.

Steve


On Sun, 28 Jan 2007 12:04:21 -0000, MartinW wrote:

Yeah I'm still a bit confused here too.
Are you just trying to turn autofilter off?
If so go to DataFilter and click on autofilter again.

HTH
Martin

You can add a "Show All" button to your favorite toolbar (especially handy if
you want to reset all the filters quickly).

Tools|Customize|Commands Tab|Data Category

Drag that "Show All" command to your favorite toolbar.

Derwood wrote:

hi
how do i get the show all button to appear in the task bar
thanks

--

Dave Peterson

Mental note, must stop forgetting those that don't have a default icon :)
Steve

On Sun, 28 Jan 2007 12:42:56 -0000, Dave Peterson
wrote:

You can add a "Show All" button to your favorite toolbar (especially
handy if
you want to reset all the filters quickly).

Tools|Customize|Commands Tab|Data Category

Drag that "Show All" command to your favorite toolbar.

Derwood wrote:

hi
how do i get the show all button to appear in the task bar
thanks

Every so often, it's not a bad idea to skim through all the built in icons.
Every version of excel adds more (or changes existing???). So it's difficult to
keep track of what's important.

SteveW wrote:

Mental note, must stop forgetting those that don't have a default icon :)
Steve

On Sun, 28 Jan 2007 12:42:56 -0000, Dave Peterson
wrote:

You can add a "Show All" button to your favorite toolbar (especially
handy if
you want to reset all the filters quickly).

Tools|Customize|Commands Tab|Data Category

Drag that "Show All" command to your favorite toolbar.

Derwood wrote:

hi
how do i get the show all button to appear in the task bar
thanks


--

Dave Peterson

On Jan 29, 12:55 am, Dave Peterson wrote:
Every so often, it's not a bad idea to skim through all the built in icons.
Every version of excel adds more (or changes existing???). So it's difficult to
keep track of what's important.



SteveW wrote:

Mental note, must stop forgetting those that don't have a default icon :)
Steve

On Sun, 28 Jan 2007 12:42:56 -0000, Dave Peterson
wrote:

You can add a "Show All" button to your favorite toolbar (especially
handy if
you want to reset all the filters quickly).

Tools|Customize|Commands Tab|Data Category

Drag that "Show All" command to your favorite toolbar.

Derwood wrote:

hi
how do i get the show all button to appear in the task bar
thanks

--

Dave Peterson

ok
in the version of excel 2002 once the show all is selected it does not
work nor highlighted when the protection is on. no problem though when
protection is deselected... any suggestions would be appreciated.

That "show all" button added to your favorite toolbar will still not work on a
protected worksheet. But you can still use the autofilter...

If you already have the outline/subtotals/autofilter applied, you can protect
the worksheet in code (auto_open/workbook_open??).

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi", userinterfaceonly:=True
'.EnableOutlining = True
.EnableAutoFilter = True
End With
End Sub

It needs to be reset each time you open the workbook. (Earlier versions of
excel don't remember it after closing the workbook. IIRC, xl2002+ will remember
the allow autofilter setting under tools|Protection|protect sheet.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm



Derwood wrote:

On Jan 29, 12:55 am, Dave Peterson wrote:
Every so often, it's not a bad idea to skim through all the built in icons.
Every version of excel adds more (or changes existing???). So it's difficult to
keep track of what's important.



SteveW wrote:

Mental note, must stop forgetting those that don't have a default icon :)
Steve

On Sun, 28 Jan 2007 12:42:56 -0000, Dave Peterson
wrote:

You can add a "Show All" button to your favorite toolbar (especially
handy if
you want to reset all the filters quickly).

Tools|Customize|Commands Tab|Data Category

Drag that "Show All" command to your favorite toolbar.

Derwood wrote:

hi
how do i get the show all button to appear in the task bar
thanks

--

Dave Peterson

ok
in the version of excel 2002 once the show all is selected it does not
work nor highlighted when the protection is on. no problem though when
protection is deselected... any suggestions would be appreciated.

--

Dave Peterson