Macro to run Command Buttons
create the following procedure in a module:
sub RunAllMacros
call Macro1
call Macro2
....
call Macro 13
end sub
create the new command button and assign the macro "RunAllMacros" to it.
Sam
"Leigh Douglass" wrote:
Hi
I have 13 individual macros assigned to 13 individual command buttons on 13
separate sheets. I would like one more command button with a macro that runs
all of the other 13 macros/buttons.
thanks
Leigh
|