Run Multiple Macros in Sequence in different Modules

[Dokat]

Hi,

I have list of Macros that are in different modules and i need to run them in sequence with one click. Can someone help me with code that will execute all macros in sequence. Thanks

CopyColumnToWorkbook ()

Vlookup ()

LookupTier ()

LookupCategory ()

ConditionalFormattingRedFE ()

SUMIFSLWFE ()

MathLWFE ()

SUMIFSL4WFE ()

SUMIFSL13WFE ()

 

[vletm]

Sub Dokat()
    CopyColumnToWorkbook
' isn't next reserved name?
     Vlookup
    LookupTier
    LookupCategory
    ConditionalFormattingRedFE
    SUMIFSLWFE
    MathLWFE
    SUMIFSL4WFE
    SUMIFSL13WFE
End Sub

 

[NARAYANK991]

Hi ,

Where you have more than one procedure with the same name in two or more different modules , remember to prefix the procedure name with the module name , as in :

Module2.SUMIFSL13WFE

Module4.SUMIFSL13WFE

Narayan

 

[Dokat]

I corrected it. However my issue is when i run multiple macros the format of the worksheet changes. Please see below link for the example file. Formatting in HDD Worksheet completely changes and and Macros in Modula 6 (Worksheet INS) doesnt work correctly. The name of the Macro in Module 1 is "RunAllMacros"

https://ufile.io/7f79y

Thanks