sbendbuckeye
Active Member
- Joined
- Nov 26, 2003
- Messages
- 440
Hello all,
How do I hook when the Excel application itself is deactivated? I have a custom menu item that needs to be reset whenever the Excel application loses focus (eg user switched to Word or email).
I am successfully hooking SheetDeactivate and WorkbookDeactivate by defining an application object as WithEvents. All that is left is to hook the Application deactivate situation. Thanks in advance for any ideas and/or suggestions!
How do I hook when the Excel application itself is deactivated? I have a custom menu item that needs to be reset whenever the Excel application loses focus (eg user switched to Word or email).
I am successfully hooking SheetDeactivate and WorkbookDeactivate by defining an application object as WithEvents. All that is left is to hook the Application deactivate situation. Thanks in advance for any ideas and/or suggestions!