Making auto filter work automatically

Question

Hi, 

In Excel 2010 I have 40 sheets that I want Auto filter to automatically update.

I'm currently using the below Macro however I have to have it on every tab within the macro page.  This then causes issues when I have to update the file as I keep getting an error message when I want to change the format of all 40 tabs for instance.  I want all 40 tabs to remain exactly the same so have to update them all together.

The code I'm using is:

Private Sub Worksheet_Change(ByVal Target As Range)

    ActiveSheet.AutoFilter.ApplyFilter

    EnableOutlining = True

End Sub

Is there a better code that I could use only within the "ThisWorkbook" code area so that it's easier to update, rather than updating 40 times,  and also to stop the code when I want to make changes to all sheets in one go?

Many Thanks for any help and advice.

Danny

Answer 1

Hi Danny,

To better assist you, please post your question on our MSDN forums on this link: MSDN forums.

Once you are on the web page, click Community, then select Forums. On the left panel, click Forums [ View all ]. Type in Excel, then select the appropriate category.

Have a great day.