Linking Macros

[Audiojoe]

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]

Sure can

Try:

Run "MyMacro1"
Run "MyMacro2"

 

[Guest]

Where would that go exactly?

 

[Dave Hawley]

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]

Lovely, thanks Dave