SheetActivate Event [Excel 2003 VBA Language Reference]
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