Not quite sure what you mean

"ducky" wrote:


'
' RefreshAutoFilter Macro
' Macro recorded 10/9/2006 by sb1920alk
'

'
ActiveSheet.Unprotect
Selection.AutoFilter Field:=1, Criteria1:="<"
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

looks like you are on the right track. store your code in a proc
called Workbook_SheetCalculate. doing that will trigger exectuion
every time there is a calculation

HTH

AR