Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Creting Master Button

Posted on 2015-01-20
15
Medium Priority
?
159 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:Naresh Patel
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
  • 2
15 Comments
 
LVL 49

Assisted Solution

by:Martin Liss
Martin Liss earned 400 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 49

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 31

Accepted Solution

by:
gowflow earned 1600 total points
ID: 40561286
Here is my solution with removing all msgboxes and keep trace.
gowflow
Incoporated-Download-File-V13.xlsm
0
Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

 
LVL 8

Author Closing Comment

by:Naresh Patel
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 31

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:Naresh Patel
ID: 40561491
;) thank you
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40561743
Welcome
0
 
LVL 31

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:Naresh Patel
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 31

Expert Comment

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

Author Comment

by:Naresh Patel
ID: 40566456
Thank you
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40566783
:)
0
 
LVL 8

Author Comment

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

Thanks
0
 
LVL 31

Expert Comment

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

Author Comment

by:Naresh Patel
ID: 40581475
Here it is.

Thanks
0

Featured Post

Office 365 Training for Admins - 7 Day Trial

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

660 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