Private Sub Workbook_newsheet
The following code works when I manually create a new worksheet, but
not when one is created from another code. Any way I can set this to
work for every instance a sheet is created regardless of whether
manual or automatically created?
Private Sub Workbook_newsheet(ByVal Sh As Object)
Sheets("Ind Templates").Range("A1:f13").Copy Sh.Range("a1")
End Sub
|