Worksheet Specific Code

[Guest]

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

 

[Dave Peterson]

This kind of code (in the worksheet module) should copy when you copy the
worksheet.

Are you copying the cells on the worksheet or are you really copying the
worksheet???

 

[Guest]

That did the trick, I was just copying the cells. Thanks for your help!