Share via


Workbook.NewSheet Event (Excel)

Occurs when a new sheet is created in the workbook.

Syntax

expression .NewSheet(Sh)

expression A variable that represents a Workbook object.

Parameters

Name

Required/Optional

Data Type

Description

Sh

Required

Object

The new sheet. Can be a Worksheet or Chart object.

Return Value

Nothing

Example

This example moves new sheets to the end of the workbook.

Private Sub Workbook_NewSheet(ByVal Sh as Object) 
 Sh.Move After:= Sheets(Sheets.Count) 
End Sub

See Also

Concepts

Workbook Object

Workbook Object Members