다음을 통해 공유


Workbook.SheetDeactivate Event (Excel)

Occurs when any sheet is deactivated.

Syntax

.SheetDeactivate(Sh, )

An expression that returns a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

Sh

필수

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

참고 항목

개념

Workbook Object

Workbook Object Members