I don’t write code but hoping to get your help. Can there be an if statement that can be added a Workbook_Open() macro, testing if a filter is on? Something like, If (the filter is on), ActiveSheet.ShowAllData, else (do something else). I really appreciate your help.