Execute multiple Specific Macro

[dimasd]

Greetings All,

I'm new in this forum. Please help me

I have specific worksheet (example WA,WB,WC,etc) which runs specific macros (MA,MB,MC,etc).
Therefore WA only run by MA; WB only run by MB, and so on.

I would like to create one master macro which run all macros. However, on one workbook sometimes contain combination on worksheet (example in Workbook 1 contains WA,WB; Workbook 2 contains WA,WD,WF; Workbook 3 contains WB,WC).

I have several workbook to run its macro. Could you help me setup one master macro to run every macros (I have 30 types of macros) regardless its worksheet combination?

Thanks before.

 

[My Aswer Is This]

Are you talking about several different Worksheets or Workbooks?
You said Quote:
I have specific worksheet
However, on one workbook

It could be very difficult to combine 30 different macros all into one. Especially if your talking about performing scripts on several different sheets in several different WorkBooks
Please clear this up for me and show me a sample of some of your scripts.

If you were able to write 30 some Macros and you know exactly what there doing as far as opening workbooks closing workbooks and so on you could write one script sort of like this which will call each script in the order you want.

Call Macrne
Call Macro_Two
Call Macro_Three

etc. etc.

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this the sort of thing you mean? If not, please try to give further clarification.

Sub RunMacros()
  Dim ws As Worksheet
  
  For Each ws In Worksheets
    Select Case ws.Name
      Case "WA": Call MA
      Case "WB": Call MB
      Case "WC": Call MC
      Case "WD": Call MD
      ')
      ') Add more Cases
      ')
    End Select
  Next ws
End Sub

 

[dimasd]

Hi Peter, thank you sooo much.

This is reaaaallyy work for me.

 

[Peter_SSs]

Hi Peter, thank you sooo much.

This is reaaaallyy work for me.

You are very welcome. I'm glad it is what you were after. Thanks for letting us know.