SheetDeactivate Event [Excel 2003 VBA Language Reference]

  • Article

Occurs when any sheet is deactivated.

Private Subobject**_SheetDeactivate(ByValShAs Object)**

objectApplication or Workbook.

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

Example

This example displays the name of each deactivated sheet.

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

Applies to | Application Object | Workbook Object

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