WindowResize Event

         Example         Applies To

Occurs when any workbook window is resized.

Syntax

Private Sub object_WindowResize(ByVal Wb As Excel.Workbook, ByVal Wn As Excel.Window)

object   Application 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.