Workbook.WindowActivate Event

Syntax

expression.WindowActivate(Wn)

expression A variable that represents a Workbook object.

Parameters

Name	Required/Optional	Data Type	Description
Wn	Required	Window	The activated window.

Example

This example maximizes any workbook window when it's activated.

Visual Basic for Applications
`Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window) Wn.WindowState = xlMaximized End Sub`

Occurs when any workbook window is activated.