SheetCalculate Event

[pwz]

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!

 

[Jim Thomlinson]

You need to catch application level events. Chekc out this link...

http://www.cpearson.com/excel/AppEvent.aspx

 

[pwz]

Dear Jim,

Very appreciate your information! I have resolved the problem now.