Refresh Autofilter
'
' 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
|