This documentation is archived and is not being maintained.

Workbook.SheetActivate Event

Office 2007
Occurs when any sheet is activated.

Syntax

expression.SheetActivate(Sh )

expression   An expression that returns a Workbook object.

Parameters

NameRequired/OptionalData TypeDescription
ShRequiredObjectThe 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



Show: