Macro help needed!

[REanalyst84]

I am trying to control multiple macros across multiple worksheets in ONE workbook... however, I can not determine what code needs to be added to create a "Master" macro. Each sheet has one macro on it... any help is greatly appreciated

 

[yuvastanza]

I am trying to control multiple macros across multiple worksheets in ONE workbook... however, I can not determine what code needs to be added to create a "Master" macro. Each sheet has one macro on it... any help is greatly appreciated

It is bit difficult to work with CSC type files. you can make a copy of it try your best

 

[Dryver14]

If you wanted to run all macro's then you need a starter macro

for instance

Sub CallMany ()

call macro1(or the name of the macro you want)
call macro2
call macro3

etc

End Sub

 

[REanalyst84]

Thanks for your response, will this allow me to control individual macros across many sheets in one workbook? I tried before by using the "Call" feature, yet it didn't seem able to run through multiple worksheets?

 

[REanalyst84]

For example,

Workbook contains about 20 worksheets... within this, 9 worksheets contain one macro each. Instead of clicking each individual page then running each macro, I want to be able to click on my main summary worksheet, click ONE button to run a master macro that will run each of the 9 macros. The "call" features seems to work if all of the macros are on one page but as soon as I want it to move to the next page, I receive an "out of range" error.

 

[REanalyst84]

OK, I resolved the issue.. thanks for the suggestions!