Activate Event

See Also         Example         Applies To

Occurs when a workbook, worksheet, chart sheet, or embedded chart is activated.

Syntax

Private Sub object_Activate()

object   Chart, Workbook, or Worksheet. For information about using events with the Chart object, see Using Events with the Chart Object.

Remarks

When you switch between two windows showing the same workbook, the WindowActivate event occurs, but the Activate event for the workbook doesn't occur.

This event doesn't occur when you create a new window.