Insert Code with Worksheet

I

iamnu

Private Sub Worksheet_Change(ByVal Target As Range)
' Do Something
End Sub

I have the above code in Sheet1 of my Workbook. When I Insert a new
Worksheet, I want the code to be copied to the new Worksheet as well,
OR have the original code work in all Worksheets.

Can someone explain how?
 
D

Don Guillett

Look in the ThisWorkbook module and use this
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)

End Sub
 
Top