Workbook.WindowActivate Event

  • Article
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