ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macros (https://www.excelbanter.com/excel-programming/322594-macros.html)

max

Macros
 
Is it possible to start an Excel macro from within another Excel macro
so that one begins at the conclusion of the other?


Ben

Macros
 
yes the syntax varies depending on where the other macro is located
if it's in the same workbook you can just type the name of the macro with
module name in front of it if you need it

sub sfsf()
'yourcode here
'end now call other macro
NEWMACRO
end sub
or

sub sfsf()
'yourcode here
'end now call other macro
module1.NEWMACRO
end sub

"max" wrote:

Is it possible to start an Excel macro from within another Excel macro
so that one begins at the conclusion of the other?



max

Macros
 
Thanks.



All times are GMT +1. The time now is 03:15 PM.

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