Workbook.SheetDeactivate Event

Syntax

expression.SheetDeactivate(Sh, )

expression An expression that returns a Workbook object.

Parameters

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

Example

This example displays the name of each deactivated sheet.

Visual Basic for Applications
`Private Sub Workbook_SheetDeactivate(ByVal Sh As Object) MsgBox Sh.Name End Sub`

Occurs when any sheet is deactivated.