Workbook.SheetDeactivate Event (Excel)

Occurs when any sheet is deactivated.

Syntax

expression .SheetDeactivate(Sh, )

expression An expression that returns a Workbook object.

Name	Required/Optional	Data Type	Description
Sh	Required	Object	The sheet. Can be a Chart or Worksheet object.

This example displays the name of each deactivated sheet.

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