WindowActivate event of the Excel application

Add-in Express™ Support Service
That's what is more important than anything else

WindowActivate event of the Excel application
nir zamir

Posts: 96
Joined: 2006-12-28

I would like to catch the event of the Excel application window catching/losing focus. The OnWindowActivate and OnWindowDeactivate events are only called when I'm switching the active window within an instance of Excel, but what I need is to know when the user switches between 2 instances of the Excel itself.

Is there any way I can do that?

Posted 20 Mar, 2007 08:05:28 Top
Sergey Grischenko

Add-in Express team

Posts: 7224
Joined: 2004-07-05
unfortunately there is not such events in the Excel Object Model.
However you can try to use application hooks to connect to events you need.
E.g. you could use the the CBTProc hook procedure to process the activate event in your add-in. Please read the 'Hooks' chapter in MSDN to lear more about it.

P.S. Note that we take up your forum requests in the order we receive them.
Besides, it may take us some time to investigate your issue. Please be sure we will let you know as soon as the best possible solution is found.
Posted 20 Mar, 2007 08:40:32 Top