Inserting VBA code into macro created sheets

[jrnyman]

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

 

[Dave Hawley]

Hi jrnyman


Easiest way is to save the Sheet with the code as a Template. Simple and very effective!

 

[jrnyman]

That's a really good idea. Is there anyway to have my macro refer to a specific template when creating new sheets, or do I have to insert the code into the standard WorkSheet template?