Skip to main content

Application.WorkbookNewSheet event

Occurs when a new sheet is created in any open workbook.


expression.WorkbookNewSheet (WbSh)

expression A variable that represents an Application object.


Name Required/Optional Data type Description
Wb Required Workbook The workbook.
Sh Required Object The new sheet.

Return value



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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>