Application.WorkbookDeactivate Event (Excel)
Occurs when any open workbook is deactivated.
Syntax
expression .WorkbookDeactivate(Wb)
expression A variable that represents an Application object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
Wb |
Required |
The workbook. |
Return Value
Nothing
Example
This example arranges all open windows when a workbook is deactivated.
Private Sub App_WorkbookDeactivate(ByVal Wb As Workbook)
Application.Windows.Arrange xlArrangeStyleTiled
End Sub