I have a template worksheet that I update and then copy 50 times (one for
each state)

There is a macro that is linked to the worksheet that executes upon double
click. How can I make this sheet specific code copy when the sheet is copied?
Or is there a way to link to another sub that will do the same thing?

Sample Code:

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As
Boolean)
'Tester Sub
MsgBox "Testing Here", vbInformation, "OH NO!"
End Sub

--
Paul