Macro limpar filtro

Boa tarde Amigos,

Tenho uma planilha com diversas colunas e utilizo vários filtros… Queria criar um botão (macro) onde eu pudesse limpar todo o filtro sem ter que fazer o caminho normal ou clicar um por um.

Desde já agradeço.

Boa tarde!
Cleber_Nego

Teste este código em uma planilha Copia para ver se funciona

Sub Auto_Open()
Dim xWs As Worksheet
For Each Wks In ThisWorkbook.Worksheets
On Error Resume Next
If Wks.AutoFilterMode Then
Wks.AutoFilterMode = False
End If
Next Wks
End Sub

Remove o filtro de toda a pasta ativa.

1 Curtida

Obrigado amigo.

Consegui resolver o problema… Abraços

Hey, I also faced with macro filer problem in my excel sheet. But I got the solution fro,this thread. BuI I faced another excel issue that was when I open my excel file that time an pop-upp notification shown on my system screen Fix MS Excel Has Stopped Working.I could not figure out what was going on in my sheet. So such types of errors really watsed our time. fOR this reason we could not compelete our work properly.