Workbook.SheetActivate Event (Excel)

Occurs when any sheet is activated.

Syntax

식 .SheetActivate(Sh )

식 An expression that returns a Workbook object.

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

This example displays the name of each activated sheet.

Private Sub Workbook_SheetActivate(ByVal Sh As Object) 
 MsgBox Sh.Name 
End Sub