Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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