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!

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

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

Jim Thomlinson


"pwz" wrote:

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!

Dear Jim,

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


"Jim Thomlinson" wrote in message
...
You need to catch application level events. Chekc out this link...

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

Jim Thomlinson


"pwz" wrote:

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!