Workbook.Deactivate Event (Excel)
Occurs when the chart, worksheet, or workbook is deactivated.
Syntax
expression .Deactivate
expression A variable that represents a Workbook object.
Return Value
nothing
Example
This example arranges all open windows when the workbook is deactivated.
Private Sub Workbook_Deactivate()
Application.Windows.Arrange xlArrangeStyleTiled
End Sub