Macro for button to click multiple buttons on separate worksheets

[topboy1120]

Aloha you guys,

I'm working on a workbook in which I'm using 6 different sheets. I modified the print settings in each of the sheets so that I can press the button corresponding to the sheet and automatically PRINT without prompting print settings.

On the last worksheet, however, I would like to add a second button which would automatically click all of the buttons in sequential order.

I have been doing some research for a few hours and the only thing that happens when I copied and modified a code was that the button printed out the 6th worksheet 6 times.

Could somebody please help me out with this? Thank you so much

 

[My Aswer Is This]

Lets assume sheet(1) had a script in it's button name One
And sheet(2) had a button with a script named Two
And so on

Well then on your last sheet put in your button which you want to click on all the other buttons a script like this:


Call One
Call Two
Call Three
Call Four

Etc.

The call function runs the script. Now obviously if your script is name Me you would have Call Me

This should work OK but it may not work properly depending on how your scripts are written.

 

[topboy1120]

Thank you very much... I realized that all of the codes called for "ActiveSheet." in Sheets 1 through 6.

I simply replaced the code for "Sheet1." "Sheet2." "Sheet3." Etc et cetera in every single button.

Now I can call every Macro individually.

The 7th button totally works now.

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.