Occurs when a new sheet is created in any open workbook.
Syntax
expression.WorkbookNewSheet (Wb, Sh)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Wb | Required | Workbook | The workbook. |
| Sh | Required | Object | The new sheet. |
Return value
Nothing
Example
This example moves the new sheet to the end of the workbook.
Private Sub App_WorkbookNewSheet(ByVal Wb As Workbook, ByVal Sh As Object)
Sh.Move After:=Wb.Sheets(Wb.Sheets.Count)
End Sub