Worksheet.Deactivate Event

Occurs when the chart, worksheet, or workbook is deactivated.

Syntax

expression.Deactivate

expression   A variable that represents a Worksheet 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

See Also

• Worksheet Object
• Worksheet Object Members