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