I run an AutoFilter in a macro, and i was wondering if there was way to hide
or remove the grey button that appears in the worksheet ?

Debra Dalgleish shows how to hide those arrows in the cells:
http://contextures.com/xlautofilter03.html#Hide



gcouch wrote:

I run an AutoFilter in a macro, and i was wondering if there was way to hide
or remove the grey button that appears in the worksheet ?

--

Dave Peterson

Thanks, i've had a look at that, and it shows how to hide them all except
one. Do you have to change much of the code for it to blank them all out ?

"Dave Peterson" wrote:

Debra Dalgleish shows how to hide those arrows in the cells:
http://contextures.com/xlautofilter03.html#Hide



gcouch wrote:

I run an AutoFilter in a macro, and i was wondering if there was way to hide
or remove the grey button that appears in the worksheet ?

--

Dave Peterson

Debra Dalgleish shows how he

http://www.contextures.com/xlautofilter03.html

under the section "Hide Filter Arrows".

Hope this helps.

Pete

On Nov 27, 9:47 pm, gcouch wrote:
I run an AutoFilter in a macro, and i was wondering if there was way to hide
or remove the grey button that appears in the worksheet ?

Rem out the lines as shown in this revision or delete them entirely.

Sub HideArrows()
'hides all arrows
Dim c As Range
Dim i As Integer
i = Cells(1, 1).End(xlToRight).Column
Application.ScreenUpdating = False

For Each c In Range(Cells(1, 1), Cells(1, i))
' If c.Column < 2 Then don't need this line
c.AutoFilter Field:=c.Column, _
Visibledropdown:=False
' End If don't need this line
Next

Application.ScreenUpdating = True
End Sub


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 14:02:04 -0800, gcouch
wrote:

Thanks, i've had a look at that, and it shows how to hide them all except
one. Do you have to change much of the code for it to blank them all out ?

"Dave Peterson" wrote:

Debra Dalgleish shows how to hide those arrows in the cells:
http://contextures.com/xlautofilter03.html#Hide



gcouch wrote:

I run an AutoFilter in a macro, and i was wondering if there was way to hide
or remove the grey button that appears in the worksheet ?

--

Dave Peterson