Is it possible to run more than one macro using one command button? if yes, how??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

samergadelrab@gmail.com - 26 Feb 2008 11:43 GMT

Hello,
I had many macros that i want to run them all at once but not upon the
opening of the excel workbook. i want to have one command button that
runs them all. is it feasible??
Samer Gamal

Reply to this Message

Roger Govier - 26 Feb 2008 12:27 GMT

Hi

Create another Macro that calls each other macro in turn.

Sub RunAll()

Call Macro1
Call Macro2
.
.
.
Call MacroX
End Sub

Signature

Regards
Roger Govier

> Hello,
> I had many macros that i want to run them all at once but not upon the
> opening of the excel workbook. i want to have one command button that
> runs them all. is it feasible??
> Samer Gamal

Reply to this Message

samergadelrab@gmail.com - 26 Feb 2008 13:05 GMT

Thanks a lot, i was just asking about the run macro command in VBA.
Thanks again, really appreciate :)

Reply to this Message