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?

Thank you! Using the Call Run Code.


"Rodrigo Ferreira" wrote:

You can create a macro that call all the others

--

Rodrigo Ferreira


"Newbee" escreveu na mensagem
...
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?

You can create a macro that call all the others

--

Rodrigo Ferreira


"Newbee" escreveu na mensagem
...
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?

Sub run_all()
macro1
macro2
macro3
End Sub


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 08:30:02 -0800, Newbee
wrote:

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?

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.

"Gord Dibben" wrote:

Sub run_all()
macro1
macro2
macro3
End Sub


Gord Dibben MS Excel MVP

On Tue, 21 Nov 2006 08:30:02 -0800, Newbee
wrote:

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?