Solved

Creting Master Button

Posted on 2015-01-20
15
128 Views
Last Modified: 2015-01-31
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
Comment
Question by:itjockey
  • 7
  • 6
  • 2
15 Comments
 
LVL 46

Assisted Solution

by:Martin Liss
Martin Liss earned 100 total points
ID: 40560497
Create a new macro and in that macro put the names of the other macros. For example

DoSomething
DoSomethingElse
GoHome
0
 
LVL 46

Expert Comment

by:Martin Liss
ID: 40560554
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
 
LVL 29

Accepted Solution

by:
gowflow earned 400 total points
ID: 40561286
Here is my solution with removing all msgboxes and keep trace.
gowflow
Incoporated-Download-File-V13.xlsm
0
 
LVL 8

Author Closing Comment

by:itjockey
ID: 40561394
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
 
LVL 29

Expert Comment

by:gowflow
ID: 40561400
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
 
LVL 8

Author Comment

by:itjockey
ID: 40561491
;) thank you
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40561743
Welcome
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 29

Expert Comment

by:gowflow
ID: 40564708
How r u enjoying you Maserrati 1 click button ? running smooth on the curves of market high's n low's !!! ??

:) :)

gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40565725
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
 
LVL 29

Expert Comment

by:gowflow
ID: 40565866
WOW amazing very nice you seem to be quite talented BRAVO !!!
gowflow
0
 
LVL 8

Author Comment

by:itjockey
ID: 40566456
Thank you
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40566783
:)
0
 
LVL 8

Author Comment

by:itjockey
ID: 40581328
May I ask question on above WB? Need One Modification.

Thanks
0
 
LVL 29

Expert Comment

by:gowflow
ID: 40581427
Yes sure go ahead
0
 
LVL 8

Author Comment

by:itjockey
ID: 40581475
Here it is.

Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now