View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Private Sub Workbook_newsheet

The code works for me when I add a new sheet via code.

Any chance that you turned off events before your code got to the portion that
added the sheet?

"J.W. Aldridge" wrote:

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


--

Dave Peterson