n Excel instance may contain several workbooks. Only one of these workbooks
may be visible. The "window deactivation:" event is fired when a workbook
comes out of focus. The OnWindowDeactivate provides facilities for trapping of
such event. The code below illustrates the technique.
Assuming that there are currently two workbooks loaded into the Excel
application, activating one of them generates the deactivation event on
another. Such event activates the handler's code and puts output into the
ControlWindow.
|