Occurs when any workbook is activated.
Syntax
expression.WorkbookActivate (Wb)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Wb | Required | Workbook | The activated workbook. |
Return value
Nothing
Remarks
For information about how to use event procedures with the Application object, see Using events with the Application object.
Example
This example arranges open windows when a workbook is activated.
Private Sub App_WorkbookActivate(ByVal Wb As Workbook)
Application.Windows.Arrange xlArrangeStyleTiled
End Sub