Export (0) Print
Expand All

Workbook.SheetDeactivate Event

Office 2007
Occurs when any sheet is deactivated.

Syntax

expression.SheetDeactivate(Sh, )

expression   An expression that returns a Workbook object.

Parameters

NameRequired/OptionalData TypeDescription
ShRequiredObjectThe 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



Community Additions

ADD
Show:
© 2015 Microsoft