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