Trigger Worksheet Activate event from within AddIn

[rolo]

Hello,

I´ve been able to trigger a workbook event from within addin using this example:
http://www.cpearson.com/excel/AppEvent.aspx

But now I need some help on how to trigger a Worksheet Activate event from within addin

Thanks!

 

[YasserKhalil]

Hello
Have a look at this sample .. May be help you out

 

[rolo]

Sorry, it does not work for me...

Don´t you need to add a class module?

 

[Debaser]

Is it for one specific sheet?

There is a workbook and/or application level SheetActivate event that you might use (simply test if the Sh argument is the sheet you are interested in), or you might use a Worksheet variable declared WithEvents.