Excel Command Buttons

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newbee - 21 Nov 2006 16:30 GMT

I am trying to create a command button that will run a series of macros.
However the command button will only allow me to assign one macro. What is
another way that I can run several macros in a sequence with one button.
Instead of having to run them one at a time?

Reply to this Message

Rodrigo Ferreira - 21 Nov 2006 17:03 GMT

You can create a macro that call all the others

Signature

Rodrigo Ferreira

>I am trying to create a command button that will run a series of macros.
> However the command button will only allow me to assign one macro. What
> is
> another way that I can run several macros in a sequence with one button.
> Instead of having to run them one at a time?

Reply to this Message

Newbee - 21 Nov 2006 17:30 GMT

Thank you! Using the Call Run Code.

> You can create a macro that call all the others
>
[quoted text clipped - 3 lines]
> > another way that I can run several macros in a sequence with one button.
> > Instead of having to run them one at a time?

Reply to this Message

Gord Dibben - 21 Nov 2006 18:01 GMT

Sub run_all()
macro1
macro2
macro3
End Sub

Gord Dibben MS Excel MVP

>I am trying to create a command button that will run a series of macros.
>However the command button will only allow me to assign one macro. What is
>another way that I can run several macros in a sequence with one button.
>Instead of having to run them one at a time?

Reply to this Message

Newbee - 21 Nov 2006 19:03 GMT

Application.run seems to be working fine. I don't know why I didn't think of
this I guess I'm just to bogged down in the details.

> Sub run_all()
> macro1
[quoted text clipped - 8 lines]
> >another way that I can run several macros in a sequence with one button.
> >Instead of having to run them one at a time?

Reply to this Message