It’s hard to remove manually AutoFilter of worksheets in multiple workbooks. I’d like to describe how to remove it with VBA. <\/p>\n
Option Explicit\r\n\r\nSub RemoveAutoFilter()\r\n    Dim Wb      As Workbook\r\n    Dim Sh      As Worksheet\r\n    Dim myPath  As Variant\r\n    Dim i       As Long\r\n    Application.ScreenUpdating = False\r\n    myPath = Application.GetOpenFilename(FileFilter:=\"Microsoft Excel Book,*.xls?\", MultiSelect:=True)\r\n    If TypeName(myPath) = \"Boolean\" Then Exit Sub\r\n    For i = LBound(myPath) To UBound(myPath)\r\n        Set Wb = Workbooks.Open(myPath(i))\r\n        For Each Sh In Wb.Worksheets\r\n            If Sh.AutoFilterMode Then\r\n                Sh.AutoFilterMode = False\r\n            End If\r\n        Next Sh\r\n        Wb.Save\r\n        Wb.Close\r\n    Next i\r\n    Application.ScreenUpdating = True\r\nEnd Sub\r\n<\/pre>\nReference:
\nApplication.GetOpenFilename Method (Excel)<\/a><\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"
It’s hard to remove manually AutoFilter of worksheets in multiple workbooks. I’d like to describe  … “How to remove AutoFilter of all worksheets in multiple Excel workbooks?” \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":6026,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[6],"tags":[],"class_list":["post-3833","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t