Workbook.SheetActivate Event

Syntax

expression.SheetActivate(Sh )

expression An expression that returns a Workbook object.

Parameters

Name	Required/Optional	Data Type	Description
Sh	Required	Object	The activated sheet. Can be a Chart or Worksheet object.

Example

This example displays the name of each activated sheet.

Visual Basic for Applications
`Private Sub Workbook_SheetActivate(ByVal Sh As Object) MsgBox Sh.Name End Sub`

Occurs when any sheet is activated.