Skip to content

Latest commit

 

History

History
51 lines (31 loc) · 1.27 KB

Excel.Application.WindowDeactivate.md

File metadata and controls

51 lines (31 loc) · 1.27 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Application.WindowDeactivate event (Excel)
vbaxl10.chm504092
vbaxl10.chm504092
Excel.Application.WindowDeactivate
6adcba54-3d4a-f780-915e-5798303faf60
04/05/2019
medium

Application.WindowDeactivate event (Excel)

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.

Remarks

For information about how to use event procedures with the Application object, see Using events with the Application object.

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

[!includeSupport and feedback]