I have six separate VBA macro modules and I need a way to run them one after
the other instead of clicking on each one, can I create a seventh macro to
chain them together?
Thank you very much

On Apr 15, 6:23*am, Sherif wrote:
I have six separate VBA macro modules and I need a way to run them one after
the other instead of clicking on each one, can I create a seventh macro to
chain them together?
Thank you very much

You could call them in your seventh macro like
Sub seven

'call macro 1'
'call macro 2'
end sub

etc

No quotes. "Call" is optional.

--
Jim
"Ixtreme" wrote in message
...
On Apr 15, 6:23 am, Sherif wrote:
I have six separate VBA macro modules and I need a way to run them one
after
the other instead of clicking on each one, can I create a seventh macro to
chain them together?
Thank you very much

You could call them in your seventh macro like
Sub seven

'call macro 1'
'call macro 2'
end sub

etc

Thank you very much it worked

"Ixtreme" wrote:

On Apr 15, 6:23 am, Sherif wrote:
I have six separate VBA macro modules and I need a way to run them one after
the other instead of clicking on each one, can I create a seventh macro to
chain them together?
Thank you very much

You could call them in your seventh macro like
Sub seven

'call macro 1'
'call macro 2'
end sub

etc