Linking Macros

Audiojoe · Mar 11th, 2002, 04:41 AM

Is it possible to link macros together, so that you can make them go off in a chain? Such as I have a macro that deletes a couple of rows, then another that formats the data into a table, then another that creates a chart. Instead of clicking three buttons, can I click one to make them all happen in turn?

Dave Hawley · Mar 11th, 2002, 04:46 AM

Sure can

Try:

Run "MyMacro1"
Run "MyMacro2"

Mar 11th, 2002, 04:52 AM

Where would that go exactly?

Dave Hawley · Mar 11th, 2002, 04:56 AM

In any normal procedure that you want to use to run all your other Procedures.

Eg

Sub DoItAll()
Run "MyMacro1"
Run "MyMacro2"
End Sub

Audiojoe · Mar 11th, 2002, 05:02 AM

Lovely, thanks Dave

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

Mar 11th, 2002, 04:41 AM	#1
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Is it possible to link macros together, so that you can make them go off in a chain? Such as I have a macro that deletes a couple of rows, then another that formats the data into a table, then another that creates a chart. Instead of clicking three buttons, can I click one to make them all happen in turn?

Mar 11th, 2002, 04:46 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Sure can Try: Run "MyMacro1" Run "MyMacro2"

Mar 11th, 2002, 04:52 AM	#3
Guest Posts: n/a	Where would that go exactly?

Mar 11th, 2002, 04:56 AM	#4
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	In any normal procedure that you want to use to run all your other Procedures. Eg Sub DoItAll() Run "MyMacro1" Run "MyMacro2" End Sub

Mar 11th, 2002, 05:02 AM	#5
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Lovely, thanks Dave