This topic has not yet been rated - Rate this topic

Application.WindowDeactivate Event

Office 2007

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

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ