Workbook.NewSheet Event

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.

Visual Basic for Applications
`Private Sub Workbook_NewSheet(ByVal Sh as Object) Sh.Move After:= Sheets(Sheets.Count) End Sub`

new new sheet New Sheet Event newsheet newsheet event When a new sheet is created in the workbook?

Occurs when a new sheet is created in the workbook.