WindowDeactivate Event

Microsoft Excel Visual Basic

Occurs when any workbook window is deactivated.

Private Sub object_WindowDeactivate(ByVal Wb As Excel.Workbook, ByVal Wn As Excel.Window)

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

Wb    Used only with the Application object. The workbook displayed in the deactivated window.

Wn    The deactivated window.

Example

This example minimizes any workbook window when it's deactivated.

Private Sub Workbook_WindowDeactivate(ByVal Wn As Excel.Window)
    Wn.WindowState = xlMinimized
End Sub