What I'm looking for is this. The code below (I think) refreshes the filter in B25 every time I move to this sheet. If, however, I manually calculate and do not move off this sheet, the filter need refreshing. I was hoping to get some code that ran the filter refresh below every time I recalculate this sheet instead of when I select this page.

Private Sub Worksheet_Activate()
Application.ScreenUpdating = False


' Refreshes that Filter in Col A so that all rows show
ActiveSheet.Range("$B$25:$W$6046").AutoFilter Field:=1

' Refreshes that Filter in Col A so that JUST the Zeros show and not the 1's which represent blank output
ActiveSheet.Range("$B$25:$W$6046").AutoFilter Field:=1, Criteria1:="-"

Application.ScreenUpdating = True
Range("A1").Select
End Sub