Workbook.WindowResize Event

  • Article
Excel Developer Reference

Occurs when any workbook window is resized.

Syntax

expression.WindowResize(Wn )

expression   A variable that represents a Workbook object.

Parameters

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

Example

This example runs when any workbook window is resized.

Visual Basic for Applications 
  Private Sub Workbook_WindowResize(ByVal Wn As Excel.Window)
    Application.StatusBar = Wn.Caption & " resized"
End Sub

See Also