Activation and Deactivation Events
Sixteen events in the Microsoft office 2010 Excel object model are raised when various objects are activated or deactivated.An object is considered activated when its window receives focus, or when it is made the selected or active object. For example, worksheets are activated and deactivated when you switch from one worksheet to another within a workbook. Clicking the tab for Sheet3 in a workbook that currently has Sheet1 selected raises a Deactivate event for Sheet1 (it is losing focus) and an Activate event for Sheet3 (it is getting focus). You can activate / deactive chart sheets in the same manner. Doing so raises Activate and Deactivate events on the Chart object corresponding to the chart sheet that was activated or deactivated.
You can also activate / deactivate workbooks. Consider the case where you have the workbooks Book1 and Book2 open at the same time. If you are currently editing Book1 and you switch from Book1 to Book2 by choosing Book2 from the Window menu, the Deactivate event for Book1 is raised and the Activate event for Book2 is raised.
Windows are another example of objects that are activated and deactivated. A workbook can have more than one window open that is showing the workbook. Consider the case where you have the workbook Book1 opened. If you choose New Window from the Window menu, two windows will open in Microsoft office 2010 Excel viewing Book1. One window has the caption Book1: 1, and the other window has the caption Book1: 2. As you switch between Book1: 1 and Book1: 2, the WindowActivate event is raised for the workbook . Switching between Book1: 1 and Book1: 2 does not raise the Workbook Activate or Deactivate events because Book1 remains the active
workbook.
Note that Activate and Deactivate events are not raised when you switch to an application other than Microsoft office 2010 Excel and then switch back to Microsoft office 2010 Excel. You might expect that if you had download Microsoft office 2010 Excel and Word open side by side on your monitor that switching focus by clicking from Microsoft office 2010 Excel toWord would raise Deactivate events inside Microsoft office 2010 Excel. This is not the case-Microsoft office 2010 Excel does not consider switching to another application a deactivation of any of its workbooks, sheets, or windows.
Microsoft Office 2010 Standard (32-bit) Download:
£89.00