Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

Workbook.SheetDeactivate Event (Excel)

Occurs when any sheet is deactivated.

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.

This example displays the name of each deactivated sheet.

Private Sub Workbook_SheetDeactivate(ByVal Sh As Object) 
 MsgBox Sh.Name 
End Sub
Show:
© 2015 Microsoft