View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cole[_2_] Cole[_2_] is offline
external usenet poster
 
Posts: 16
Default 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