Activates the object, as shown in the following table.
| Object | Description |
|---|---|
| Chart, ChartObject | Makes this chart the active chart. |
| Worksheet | Makes this sheet the active sheet. Equivalent to clicking the sheet’s tab. |
| OLEObject | Activates the object. |
| Pane | Activates the pane. If the pane isn’t in the active window, the window that the pane belongs to will also be activated. You cannot activate a frozen pane. |
| Range | Activates a single cell, which must be inside the current selection. To select a range of cells, use the Select method. |
| Window | Brings the window to the front of the z-order. This won’t run any Auto_Activate or Auto_Deactivate macros that might be attached to the workbook (use the RunAutoMacros method to run those macros). |
| Workbook | Activates the first window associated with the workbook. This won’t run any Auto_Activate or Auto_Deactivate macros that might be attached to the workbook (use the RunAutoMacros method to run those macros). |
Syntax
expression.Activate
expression Required. An expression that returns an object in the Applies To list.