Macro for Auto Filter to hide on some columns

[scottmac]

Hi can anyone please help me with a macro code please

I want to hide auto filter on the following columns A,B,C,F,G,N,M,AB,AD
But want to show in all other columns

How can i do this?

been trying all day and i bet it is simple lol i am using excel 2003

 

[Michael M]

Try, Assuming your dropdown arrows are in row 1

Sub Hide_Dropdown()
With Range("A1:AD1")
    .AutoFilter field:=1, Visibledropdown:=False
    .AutoFilter field:=2, Visibledropdown:=False
    .AutoFilter field:=3, Visibledropdown:=False
    .AutoFilter field:=6, Visibledropdown:=False
    .AutoFilter field:=7, Visibledropdown:=False
    .AutoFilter field:=13, Visibledropdown:=False
    .AutoFilter field:=14, Visibledropdown:=False
    .AutoFilter field:=28, Visibledropdown:=False
    .AutoFilter field:=30, Visibledropdown:=False
End With
End Sub

 

[scottmac]

Worked thanks

Try, Assuming your dropdown arrows are in row 1

Sub Hide_Dropdown()
With Range("A1:AD1")
    .AutoFilter field:=1, Visibledropdown:=False
    .AutoFilter field:=2, Visibledropdown:=False
    .AutoFilter field:=3, Visibledropdown:=False
    .AutoFilter field:=6, Visibledropdown:=False
    .AutoFilter field:=7, Visibledropdown:=False
    .AutoFilter field:=13, Visibledropdown:=False
    .AutoFilter field:=14, Visibledropdown:=False
    .AutoFilter field:=28, Visibledropdown:=False
    .AutoFilter field:=30, Visibledropdown:=False
End With
End Sub

 

[Michael M]

pleasure...