show all button

M

MartinW

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
 
D

Derwood

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....
 
S

SteveW

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
 
M

MartinW

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

HTH
Martin
 
S

SteveW

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
 
D

Dave Peterson

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.
 
D

Dave Peterson

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.
 
D

Derwood

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.
Click to expand...

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.
 
D

Dave Peterson

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
 
Top