Reply to thread

Message: [QUOTE="KC hotmail com>, post: 3238464"] Right-click that sheet's tab and select "View Code." Paste this macro in, modify it to represent the columns you want the filter button on, press the green play button, delete the macro, then exit the VBA editor window. That's it! Sub HideSomeArrows() 'hide some autofilter arrows Dim c As Range Dim i As Integer 'Assumes headers begin in A1 (1,1)...change as needed in both places below i = Cells(1, 1).End(xlToRight).Column Application.ScreenUpdating = False For Each c In Range(Cells(1, 1), Cells(1, i)) Select Case c.Column 'These are the columns you want to show 'In this example, starting from A1, 2 is column B and 3 is column C 'So this will hide the filter button in column A and columns D to the end Case 2, 3 'Change accordingly c.AutoFilter Field:=c.Column, _ Visibledropdown:=True Case Else c.AutoFilter Field:=c.Column, _ Visibledropdown:=False End Select Next Application.ScreenUpdating = True End Sub [/QUOTE]