one button for many (macro)
 

I've got a sheet in a workbook where I put 6 buttons; each one is assigned
to a macro and for my purpouse (and to control that code I write do the
right thins) I press them sequentially from 1 to 6 . Now, how can I define
another

TIA button that "press" buotton from 1 to 6 sequentially...?

one button for many (macro)
 

Hi

You can call several macros from one, that is pretty essential in
programming:

Sub Macrocollection()
Call Macro1
Call Macro2
Call Macro3
End Sub

Sub Macro1()
MsgBox "1"
End Sub

Sub Macro2()
MsgBox "2"
End Sub

Sub Macro3()
MsgBox "3"
End Sub

HTH. Best wishes Harald

"uriel78" skrev i melding
...
I've got a sheet in a workbook where I put 6 buttons; each one is assigned
to a macro and for my purpouse (and to control that code I write do the
right thins) I press them sequentially from 1 to 6 . Now, how can I define
another

TIA button that "press" buotton from 1 to 6 sequentially...?

one button for many (macro)
 

You don't, you create a new macro assigned to that button that runs the 6
macros sequentially.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"uriel78" wrote in message
...
I've got a sheet in a workbook where I put 6 buttons; each one is assigned
to a macro and for my purpouse (and to control that code I write do the
right thins) I press them sequentially from 1 to 6 . Now, how can I define
another

TIA button that "press" buotton from 1 to 6 sequentially...?

one button for many (macro)
 

thank you all!