WindowActivate Event

See Also         Example         Applies To

Occurs when any workbook window is activated.

Syntax

Private Sub object_WindowActivate(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 activated window.

Wn   The activated window.