Application.WorkbookNewSheet Event (Excel)
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 |
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