Combine 5 Macros

[PMARI]

Dear All,

I am having limited experience with VBA. Created 5 macros with key shortcuts to complete a report. Named as INV 1, INV 2....INV 5 working fine , when run one after other.

Is there any way to run with one activation key.

Please provide code.

Thanks in advance.

 

[CharlesChuckieCharles]

Public Sub CompleteReport()
Call inv1()
Call inv2()
Call inv3()
Call inv4()
Call inv5()
end sub

 

[kpark91]

Well if you have macros named:
Macro1
Macro2
Macro3
Macro4
Macro5

If you want to execute the codes from all five one after another (1 to 5) you could:

Sub fireAll()
    Call Macro1
    Call Macro2
    Call Macro3
    Call Macro4
    Call Macro5
End Sub

 

[PMARI]

Dear Charles & kpark,

thanks for reply

miserably both codes are nor working for me.

Please see my Macro links for your consideration
http://www.speedyshare.com/files/28903889/Macro1.xlsm
http://www.speedyshare.com/files/28903900/Macro2.xlsm

pl.help out.
Regards,
PM