Procedure to remove filters from all worksheets
Author: michael@excelexperts.co.uk
Sub Filters_RemoveFromWorkbook()
Dim sht As Worksheet
For Each sht In ThisWorkbook.Worksheets
sht.AutoFilterMode = False
Next sht
End Sub
Procedure to remove filters from all worksheets
Author: michael@excelexperts.co.uk
Sub Filters_RemoveFromWorkbook()
Dim sht As Worksheet
For Each sht In ThisWorkbook.Worksheets
sht.AutoFilterMode = False
Next sht
End Sub