Excel.Workbook.SheetActivate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.SheetActivate event (Excel)	vbaxl10.chm503088	vbaxl10.chm503088	Excel.Workbook.SheetActivate	2a7c05c3-5b66-8012-5ac5-981dcfc7f947	05/29/2019	medium

Workbook.SheetActivate event (Excel)

Occurs when any sheet is activated.

Syntax

expression.SheetActivate (Sh)

expression An expression that returns a Workbook object.

Parameters

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

Example

This example displays the name of each activated sheet.

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

[!includeSupport and feedback]