G
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
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