| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
Workbook.WindowResize event (Excel) |
vbaxl10.chm503082 |
|
|
6e473482-fe16-03a2-7a27-b0cd9535c3e6 |
05/29/2019 |
medium |
Occurs when any workbook window is resized.
expression.WindowResize (Wn)
expression A variable that represents a Workbook object.
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Wn | Required | Window | The resized window. |
This example runs when any workbook window is resized.
Private Sub Workbook_WindowResize(ByVal Wn As Excel.Window)
Application.StatusBar = Wn.Caption & " resized"
End Sub[!includeSupport and feedback]