Workbook.WindowResize Event (Excel)
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.
Private Sub Workbook_WindowResize(ByVal Wn As Excel.Window)
Application.StatusBar = Wn.Caption & " resized"
End Sub