Inserting VBA code into macro created sheets

jrnyman · Apr 9th, 2002, 12:55 AM

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 · Apr 9th, 2002, 03:49 AM

Hi jrnyman

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

jrnyman · Apr 9th, 2002, 04:16 AM

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?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 12:55 AM	#1
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	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

Apr 9th, 2002, 03:49 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi jrnyman Easiest way is to save the Sheet with the code as a Template. Simple and very effective!

Apr 9th, 2002, 04:16 AM	#3
jrnyman Board Regular Join Date: Mar 2002 Location: Boston, MA Posts: 105	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?