Clear Filters on Exit

Originally Posted by romperstomper

There's no syntactical difference between Private and Public functions - the only difference is where you can call them from.
What you want is basically:

Dim wks As Worksheet
For each wks in activeworkbook.worksheets
   wks.autofiltermode = false
next wks

Thanks very much. I'm learning all the time. Realised I had get this line in at the beginning

Private Sub Workbook_Open()

.

So everything in This Workbook is invoked when the workbook is opend and closed?