Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

Creting Master Button

Hi Experts,

I have one WB in which there is 6 buttons which perform different 6 task independently. I need to create one master button in WB, so that after clicking that all 6 Button task perform line by line. No need of pop messages - just click and all done i.e. only one click.

see attached

Thanks
Incoporated-Download-File-V05.xlsm
0
Naresh Patel
Asked:
Naresh Patel
  • 7
  • 6
  • 2
2 Solutions
 
Martin LissOlder than dirtCommented:
Create a new macro and in that macro put the names of the other macros. For example

DoSomething
DoSomethingElse
GoHome
0
 
Martin LissOlder than dirtCommented:
I didn't realize that you were using ActiveX controls. I've added a new button in the attached workbook that does what you want.
Q-28600396.xlsm
0
 
gowflowCommented:
Here is my solution with removing all msgboxes and keep trace.
gowflow
Incoporated-Download-File-V13.xlsm
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Naresh PatelTraderAuthor Commented:
Sir.Martin Liss,
Your Code worked Perfect But it popups messages. I want to override all messages and need to just clicked once, which i mentioned in my very first post.

Sir Gowflow,
Guruji  PERFECT.
0
 
gowflowCommented:
Pls note I also updated all the trace to show if you have selected trace show when you activate do it all as it is very important to follow and make sure all stages have been performed. It was sometime resetting the trace when you run the buttons individually ... reason why I had to post the whole workbook and not just ammendments as had to make several changes a bit everywhere !!!!

Your a NO MSGBOX MAN ... so we need cater for this :)

gowflow
0
 
Naresh PatelTraderAuthor Commented:
;) thank you
0
 
gowflowCommented:
Welcome
0
 
gowflowCommented:
How r u enjoying you Maserrati 1 click button ? running smooth on the curves of market high's n low's !!! ??

:) :)

gowflow
0
 
Naresh PatelTraderAuthor Commented:
Yes Sir, Working Fine. In recent months (Dec - Jan) I am little busy in wedding season in my country, I do wedding setups (Decoration). From Monday onwards I will  devote my full time in stock market. there is lots of thing to implement other than above solution, all most all code is ready just need to incorporate in one WB. Sure I will let you know in this question as link.
This is my setup work :)1StageGate2
Thank You
0
 
gowflowCommented:
WOW amazing very nice you seem to be quite talented BRAVO !!!
gowflow
0
 
Naresh PatelTraderAuthor Commented:
Thank you
0
 
gowflowCommented:
:)
0
 
Naresh PatelTraderAuthor Commented:
May I ask question on above WB? Need One Modification.

Thanks
0
 
gowflowCommented:
Yes sure go ahead
0
 
Naresh PatelTraderAuthor Commented:
Here it is.

Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 7
  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now