View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
 
Posts: 425
Default 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