Workbook.WindowActivate Event (Excel)

Occurs when any workbook window is activated.

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.

Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window) 
 Wn.WindowState = xlMaximized 
End Sub

See also

Workbook Object