use a command button to click other command buttons

Hi
Thanks for taking time to help
I would like a code that will let
Command Button1 on click
To click five other Command Buttons (2-6)
All Buttons are on same work sheet
I can make button1 click one other button but not 5 other buttons
Thanks
for any Help

hi,

Why instead of clicking all the button just program the button to execute the code for the other 5.
Thanks

you do what they suggested by using the Call command. So if you have a Sub called Test your command would be

Please Login or Register  to view this content.