Workbook.NewSheet Event

  • Article
Excel Developer Reference

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.

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

See Also