Application.WindowDeactivate Event

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`

Occurs when any workbook window is deactivated.