Application.WorkbookActivate Event (Excel)
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 |
The activated workbook. |
Return Value
Nothing
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