Looping Macro Advice Please

[StewartS]

Hi

I have a number of macros which use the same loop data to change 300 individual workbooks but perform different activities within the loop, such as updating actual and budget data, resetting workbooks from read only to write, updating the module in the workbooks etc.

I have a menu sheet with buttons on which are used to run these macros as required. What I was wondering is how I could reduce the amount of code by possibly allowing the main loop macro to select and run the appropriate macro within the loop.

As an example selecting button 1 would select the loop macro and choose to run macro 1 in it whilst similarly button 2 would run macro 2 etc. I'm Ok with calling the macro within the loop it is just how to select it that I'm unsure of.

Any suggestions would be welcome.

Thanks

StewartS

 

[Stridhan]

just a wild guess, cant use "select case" based on which button is clicked?

 

[My Aswer Is This]

You can run one macro from inside another macro by using the "Call" function. Example

For i = 1 To 20
Call Macroname
Next

 

[StewartS]

Thanks

These were the sort of things I was thinking of, just good to get some confirmation.

StewartS