Click a Command Button using vba

[spq24]

I have a series of command buttons lined up one after the other. Each controlling a different macro. When macro 1 is done I want it to click on the command button for macro 2

so:
user clicks command button 1
Macro 1 runs
Command Button 2 is automatically clicked on after Macro 1 is done running
Macro 2 runs (controlled by command button 2)

Any help much appreciated thanks!

 

[John Davis]

I have a series of command buttons lined up one after the other. Each controlling a different macro. When macro 1 is done I want it to click on the command button for macro 2

so:
user clicks command button 1
Macro 1 runs
Command Button 2 is automatically clicked on after Macro 1 is done running
Macro 2 runs (controlled by command button 2)

Any help much appreciated thanks!

Would it be practicle for your purposes to just call Macro 2 at the end of Macro 1?

 

[spq24]

calling the button hasn't worked out for me. I'm using the Application.Run (["macro1"]) and thats working