Hi all,

The Macro1 below was not evoke upon the calculation of active worksheet. I
put these codes under ThisWorkBook but saved as addin (.xla) file. The
auto-filter was set on the newly created worksheet.

Private Sub Workbook_SheetCalculate(ByVal ob As Objects)
If ob.AutoFilterMode Then Macro1
End Sub

Should these event code must be placed under ThisWorkBook of newly created
worksheet in order to call Macro1? Thanks in advance!