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...?
|