Workbook NewSheet Event

Syntax
Private Sub Workbook_NewSheet(ByVal Sh As Object)
Enter Code
End Sub

This event will run every time a new worksheet is created within the specific workbook.

Required Parameters
Sh
The sh parameter returns the newly created worksheet as a worksheet object to allow users to manipulate the events, methods and properties.