WindowResize Event [Excel 2003 VBA Language Reference]

Occurs when any workbook window is resized.

Private Subobject**_WindowResize(ByValWbAs Excel.Workbook**, ByValWnAs Excel.Window)

objectApplication or Workbook. For more information about using events with the Application object, see Using Events with the Application Object .

Wb Used only with the Application object. The workbook displayed in the resized window.

Wn 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

Applies to | Application Object | Workbook Object