[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Follow Up

Posted on 2015-02-03
12
Medium Priority
?
151 Views
Last Modified: 2016-02-11
Hi Experts,

I have one WB in which I have too many buttons which execute different subs. I have one button called "Do It All" . want to assign this button as master button so after clicking this button all sub executed with out messages. except last button "Future & Option" Sub.

See attached

Thanks
Incoporated-Download-File-V17.xlsm
0
Comment
Question by:Naresh Patel
  • 6
  • 4
  • 2
12 Comments
 
LVL 51

Expert Comment

by:Martin Liss
ID: 40587315
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40587319
I had added more buttons in same WB.

Thanks
0
 
LVL 51

Expert Comment

by:Martin Liss
ID: 40587338
Well goflow provided a solution that should be easy to modify to include more buttons.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
LVL 31

Accepted Solution

by:
gowflow earned 2000 total points
ID: 40587343
ok here it is

1) make a copy of your current workbook and give it a new name
2) Open it and goto VBA and doubleclick on sheet Main
3) select Commandbutton15_click and delete the code that is between Sub Commandbutton15 and End Sub
4) Paste the below code after commandbutton15_click

bDoit = True

Sheets("Main").Range("A14:I" & Sheets("Main").Rows.Count).ClearContents

CommandButton1_Click
CommandButton2_Click
CommandButton3_Click
CommandButton4_Click
CommandButton5_Click
CommandButton6_Click
CommandButton7_Click

MsgBox "Do it all completed successfully !", vbInformation, "Do it All"

Open in new window


5) SAVE and exit the workbook.
6) open it and try it.

gowflow
0
 
LVL 8

Author Closing Comment

by:Naresh Patel
ID: 40587399
Perfect - Just One Thing Need To Know - If I change directories in setting sheet, it will auto download and format in that directories... mi right?
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40587992
yes whatever you change in settings is reflected automatically in the whole macro whether in http or in destination folder.

gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40588043
Thanks
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40588509
Welcome
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40589396
May I ask question?
0
 
LVL 31

Expert Comment

by:gowflow
ID: 40589507
Yes sure
gowflow
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40589622
Follow Up


Thanks
0
 
LVL 8

Author Comment

by:Naresh Patel
ID: 40589643
Follow Up

Edited as wrong file attached so I don't know link is changed or not so posted again.

Thanks
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

In this article, I will demonstrate that how to do a PST migration from Exchange Server to Office 365. This method allows importing one single PST, or multiple PST's at once.
Are you looking to start a business? Do you own and operate a small company? If so, here are some courses you need to take before you hire a full-time IT staff.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

613 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