k0st4din
02-21-2014, 01:06 PM
Hello to all
I would like to ask you if there is a way to activate several macro one button in a sheet. And then in the next sheet to reactivate a few (chosen by me) macros, and so for all other sheets.
Here's what I used for the first macro:
Sub CallMacros()
Macros in Module1 and Module2 and Module3 'Macros are triggered by one button in Sheet1
End Sub
Would it be okay if I do the same macro(Sub CallMacros), but changed the names of other macros, or if duplicate names(Sub CallMacros) will be a problem?
Sub CallMacros()
Macros in Module4 and Module7 and Module33 'Macros are triggered by one button in Sheet2
End Sub
If there's something you do not understand, please ask me
Thank you in advance.
I would like to ask you if there is a way to activate several macro one button in a sheet. And then in the next sheet to reactivate a few (chosen by me) macros, and so for all other sheets.
Here's what I used for the first macro:
Sub CallMacros()
Macros in Module1 and Module2 and Module3 'Macros are triggered by one button in Sheet1
End Sub
Would it be okay if I do the same macro(Sub CallMacros), but changed the names of other macros, or if duplicate names(Sub CallMacros) will be a problem?
Sub CallMacros()
Macros in Module4 and Module7 and Module33 'Macros are triggered by one button in Sheet2
End Sub
If there's something you do not understand, please ask me
Thank you in advance.