SheetActivate Event [Excel 2003 VBA Language Reference]

  • Article

Occurs when any sheet is activated.

Private Subobject**_SheetActivate(ByValShAs Object)**

objectApplication or Workbook.

Sh The activated sheet. Can be a Chart or Worksheet object.

Example

This example displays the name of each activated sheet.

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

Applies to | Application Object | Workbook Object

See Also | Activate Method | Deactivate Event | SheetDeactivate Event | WindowActivate Event | WindowDeactivate Event | WorkbookActivate Event | WorkbookDeactivate Event