SheetDeactivate Event

Applies To

Application object, Workbook object.

Description

Occurs when any sheet is deactivated.

Syntax

Private Sub object_SheetDeactivate(ByVal Sh As Object)

object Application or Workbook.

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

See Also

Activate event, Deactivate event, SheetActivate event, WindowActivate event, WindowDeactivate event, WorkbookActivate event, WorkbookDeactivate event.

Example

This example displays the name of each deactivated sheet.

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