http://www.cpearson.com/excel/events.htm

for an overview of events. (Chip Pearson's site)

--
Regards,
Tom Ogilvy


"sb1920alk" wrote in message
...
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