I have a macro that generates a few charts, and i would like to have the macro automatically include this code with each of those new chart sheets. How can I do this? The code to include is:
Private Sub Chart_BeforeDoubleClick(ByVal ElementID As Long, ByVal Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
Sheets("Sales Reports").Select
End Sub
Private Sub Chart_BeforeDoubleClick(ByVal ElementID As Long, ByVal Arg1 As Long, ByVal Arg2 As Long, Cancel As Boolean)
Sheets("Sales Reports").Select
End Sub