How to get a filter to run each time a file is saved?

[Laybenet]

I have three sheets.
Each sheets have filters set on ROW # 3 for the data below.
People will make changes on the rows below.
I only want to show rows that are "Pending" only.
For rows that are "Complete", I want to hide/filter them out.

Currently the filter only works when I set it.
When I make a change of a new row from "Pending" to "Complete" and I save it and come back, the row is still there with "Complete". It should have been filtered out.

Please help.

Thank you.

 

[doofusboy]

You could try placing code to do your filtering here:

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
End Sub