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.