Multi Macro
 

Hi all,
I currently have 3 buttons that each activate a macro.
Does anyone know how i can have all 3 macros run in order under one button.

Thanks
Toms

Multi Macro
 

One way:

Have the button call Macro1:


Public Sub Macro1()
'Do something
Macro2
Macro3
End Sub

Public Sub Macro2()
'Do something else
End Sub

Public Sub Macro3()
'Something else again
End Sub


In article ,
GarToms wrote:

I currently have 3 buttons that each activate a macro.
Does anyone know how i can have all 3 macros run in order under one
button.