Application.WindowDeactivate Event

  • Article
Excel Developer Reference

Occurs when any workbook window is deactivated.

Syntax

expression.WindowDeactivate(Wb, Wn)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
Wb Required Workbook The workbook displayed in the deactivated window.
Wn Required Window The deactivated window.

Example

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

Visual Basic for Applications 
  Private Sub Workbook_WindowDeactivate(ByVal Wn As Excel.Window)
    Wn.WindowState = xlMinimized
End Sub

See Also