Deactivate Event

Microsoft Excel Visual Basic

Deactivate Event

       

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

Private Sub object_Deactivate()

object   Chart, Workbook, or Worksheet. For information about using events with the Chart object, see Using Events with the Chart Object.

Example

This example arranges all open windows when the workbook is deactivated.

Private Sub Workbook_Deactivate()
    Application.Windows.Arrange xlArrangeStyleTiled
End Sub