WindowActivate Event [Excel 2003 VBA Language Reference]

  • Article

Occurs when any workbook window is activated.

Private Subobject**_WindowActivate(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 activated window.

Wn The activated window.

Example

This example maximizes any workbook window when it's activated.

Private Sub Workbook_WindowActivate(ByVal Wn As Excel.Window)
    Wn.WindowState = xlMaximized
End Sub

Applies to | Application Object | Workbook Object

See Also | Activate Method | Deactivate Event | SheetActivate Event | SheetDeactivate Event | WindowDeactivate Event | WorkbookActivate Event | WorkbookDeactivate Event