Share via


Workbook.WindowActivate Event

Excel Developer Reference

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.

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

See Also