Update but not change a filter selelction

[cogswel__cogs]

I have a report that uses a pivotable.
There is a filter that encompasses the entire pivot table but is not the pivottable itself.
For what I am trying to do with this works great, However when certain slicers are chosen the pivot resets, rows move so the hiden rows no longer align with the filtered selection.
This is easily corrected by selecting the filter and then just hitting okay to keep the current selection as is. This resets the rows to the propper criteria.
I was hoping to automate that anyone have a suggestion as to how.

 

[cogswel__cogs]

Figured it out
This gets it done.


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