Add-ins and Worksheet activate

[HSalim[MVP]]

I am working on creating an addin. This add-in adds a command bar to Excel
and operates on the current workbook.
As the user moves between worksheets in the activeworkbook, I want to
execute code on the worksheet.activate event.
How do I do that?

Thanks in advance for your help

Regards

 

[Guest]

You need to catch the events at the application level. Here is a great
resource on that...

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

 

[HSalim[MVP]]

Perfect! Sounds like just what I want.
Thank you.
Habib

--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40

 

[HSalim[MVP]]

Jim,
Thanks again; yes that works.
Refining the idea... This add-in should only work on certain workbooks.
The user creates the workbook from a template but saves with any file name.

I thought I'd create a custom document property, Then check for that
document property before executing vba routines from the add-in.

Any thoughts on that?

Regards
Habib


--
www.DynExtra.com
A resource for the Microsoft Dynamics Community
Featuring FAQs, File Exchange and more
Current member count: 40