Can someone help me understand why the following is not working?



Private Sub Worksheet_Open()
   Sheets("PROJECTS").AutoFilter.ApplyFilter

End Sub

I have this placed in "ThisWorkbook". It works perfectly when I did it as a "Change" function. The problem was the spreadsheet was extremely jumpy and too much. Now i just wanted it to reorganize it automatically when I open the spreadsheet. Any ideas?

Here is the original code that worked perfectly.

Private Sub Worksheet_Change(ByVal Target As Range)
   Sheets("Projects").AutoFilter.ApplyFilter
End Sub