Excel.Workbook.SheetDeactivate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.SheetDeactivate event (Excel)	vbaxl10.chm503089	vbaxl10.chm503089	Excel.Workbook.SheetDeactivate	befde22b-69ce-c34f-2b9e-da5e026972e3	05/29/2019	medium

Workbook.SheetDeactivate event (Excel)

Occurs when any sheet is deactivated.

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.

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

[!includeSupport and feedback]