title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|
Workbook.NewSheet event (Excel) |
vbaxl10.chm503079 |
|
|
5abb254d-a2c3-7dac-e79f-0de74a081ecd |
05/29/2019 |
medium |
Occurs when a new sheet is created in the workbook.
expression.NewSheet (Sh)
expression A variable that represents a Workbook object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
Sh | Required | Object | The new sheet. Can be a Worksheet or Chart object. |
Nothing
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
[!includeSupport and feedback]