Workbook Reset AutoFilter to ShowAll

[David J]

I have a large workbook that has the Autofilter available for many people to
view and I want to be able to reset the Autofilter to Show All before the
workbook is saved or closed. Please explain how in code clearly for this
novice.

 

[Dave Peterson]

I found that it's better to reset the autofilter when the workbook is opened.

If you reset it when you close the workbook, you'll have to save the workbook.
And your users may not want to save their changes.

This goes into a General module:

Option Explicit
Sub auto_open()
dim wks as worksheet
for each wks in thisworkbook.worksheets
with wks
If .FilterMode Then
.ShowAllData
End If
end with
next wks
End Sub