This documentation is archived and is not being maintained.

Workbook.WindowResize Event

Office 2007
Occurs when any workbook window is resized.

Syntax

expression.WindowResize(Wn )

expression   A variable that represents a Workbook object.

Parameters

NameRequired/OptionalData TypeDescription
WnRequiredWindowThe 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



Show: