ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro to run macros (https://www.excelbanter.com/excel-programming/277515-macro-run-macros.html)

JamesA

Macro to run macros
 
I have six macros in a ws which I wish to run sequentially
on one click. Can someone help with macro or vb to do that.

Regards,
JA

Cole[_2_]

Macro to run macros
 
if in the same module

Sub Control()
Call macro1
Call macro2
Call macro3
Call macro4
Call macro5
Call macro6
End Sub

if in different module
call module1.marco1

"jamesa" wrote in message
...
I have six macros in a ws which I wish to run sequentially
on one click. Can someone help with macro or vb to do that.

Regards,
JA




M.

Macro to run macros
 
here u a

Sub Makro1()
'
End Sub

Sub Makro2()
'
End Sub
....
Sub RnuSequentially()
Makro1
Makro2
End Sub

Regards,
Milos

"jamesa" wrote in message
...
I have six macros in a ws which I wish to run sequentially
on one click. Can someone help with macro or vb to do that.

Regards,
JA





All times are GMT +1. The time now is 06:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com