Excel.Application.WorkbookDeactivate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Application.WorkbookDeactivate event (Excel)	vbaxl10.chm504083	vbaxl10.chm504083	Excel.Application.WorkbookDeactivate	0a6a55ea-5374-4de7-e48e-e52d903cc749	04/05/2019	medium

Application.WorkbookDeactivate event (Excel)

Occurs when any open workbook is deactivated.

Syntax

expression.WorkbookDeactivate (Wb)

expression A variable that represents an Application object.

Parameters

Name	Required/Optional	Data type	Description
Wb	Required	Workbook	The workbook.

Return value

Nothing

Example

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

Private Sub App_WorkbookDeactivate(ByVal Wb As Workbook) 
 Application.Windows.Arrange xlArrangeStyleTiled 
End Sub

[!includeSupport and feedback]