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 | Workbook | 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