View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default 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