T Tom Ogilvy Feb 23, 2004 #2 If you mean turn off any autofilters: Private Sub Workbook_Open() for each sh sh.AutofilterMode = False Next End Sub
If you mean turn off any autofilters: Private Sub Workbook_Open() for each sh sh.AutofilterMode = False Next End Sub