Assign two macros to a command button, but only one can automatically run!!

**paulyb** · 03-14-2012, 10:45 AM

Hi,

I am trying to use one control button to run the below two macros, i.e., Score1 and hide_rows with the same module. But only the sheets("Score1").Select can automatically run when the control button on the Menu sheet was clicked. Does anybody can help me to fix these? btw, the macro "Score1" have already been assigned to the control button. Many thanks for your kind help and time.

Paul

Please Login or Register  to view this content.

**Domski** · 03-14-2012, 10:47 AM

Please take a moment to read the forum rules and edit your post to include code tags.

Dom

**Domski** · 03-14-2012, 11:28 AM

Thanks,

You are already calling the hide_rows macro from the Score1 one so they should both run. Another option is to have a third macro that calls each macro you want to run in order and attach that to the button:

Please Login or Register  to view this content.

Dom

**paulyb** · 03-14-2012, 11:44 AM

Thank you very much, Dom.

Yes, I also think the second macro should run at the same time. However, it did not. I will try your suggestion and see whether it can work or not.

Thanks,

Paul

Originally Posted by Domski

Thanks,

You are already calling the hide_rows macro from the Score1 one so they should both run. Another option is to have a third macro that calls each macro you want to run in order and attach that to the button:

Please Login or Register  to view this content.

Dom

**paulyb** · 03-14-2012, 11:56 AM

The second macro ("hide_rows") still cannot run automatically together with the process of the sheets("Score1").Select after I clicked the button that was assigned with Run_All_Macros. Any other suggestions?

Thanks,

Originally Posted by Domski

Thanks,

You are already calling the hide_rows macro from the Score1 one so they should both run. Another option is to have a third macro that calls each macro you want to run in order and attach that to the button:

Please Login or Register  to view this content.

Dom

**Domski** · 03-14-2012, 11:56 AM

This might be worth a read: http://www.cpearson.com/excel/debug.htm

You could step through your code and see whether it is executing as expected or pop a break point in and see if it gets to it.

Please also don't quote whole posts in your replies.

Dom

**paulyb** · 03-14-2012, 12:50 PM

Still have no idea what's wrong with the codes. Any ones could give me a hint? Appreciate!

**Domski** · 03-14-2012, 01:06 PM

Would need to see a sample workbook to have any real idea.

Dom

Assign two macros to a command button, but only one can automatically run!!

LinkBack

Thread Tools

Rate This Thread

Display

Assign two macros to a command button, but only one can automatically run!!

Re: Assign two macros to a command button, but only one can automatically run!!

Re: Assign two macros to a command button, but only one can automatically run!!

Re: Assign two macros to a command button, but only one can automatically run!!

Re: Assign two macros to a command button, but only one can automatically run!!

Re: Assign two macros to a command button, but only one can automatically run!!

Re: Assign two macros to a command button, but only one can automatically run!!

Re: Assign two macros to a command button, but only one can automatically run!!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions