Click once

S

Sheree

New Member
Joined
Jan 13, 2005
Messages
24
Hi Guys,

I would like to click once and 5 macros go into action, how do I do this?

I can't put the macros together because they don't run the way I like.

Sheree
 
Sort by date Sort by votes
Using Smitty's code something like this:

Private Sub CommandButton1_Click()
For Each Worksheet In Application.Workbooks
Application.Run "Macro1"
Sheets("Sheet2").Activate
Application.Run "Macro2"
Sheets("Sheet3").Activate
Application.Run "Macro3"
Sheets("Sheet4").Activate
Application.Run "Macro4"
Sheets("Sheet5").Activate
Application.Run "Macro5"
Sheets("Sheet6").Activate
Next Worksheet
End Sub
 
Upvote 0

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
You must log in or register to reply here.

Similar threads

B
  • Question
VBA to save as 'Excel Workbook' (not Macro enabled)
Replies
4
Views
378
frabulator
frabulator
M
  • Solved
procedure to populate message box with yes or no if I run the macro
Replies
3
Views
210
Michael M
Michael M
S
  • Solved
add a message box if a match using a userform list box doesn't match
Replies
7
Views
208
still learning
S
T
  • Question
Multiple filters on filtered list
Replies
1
Views
293
Cubist
Cubist
RogueRoustabout
  • Question
Macro for updating the date, in a cell... maybe
Replies
5
Views
202
MARK858
MARK858

Forum statistics

Threads
1,216,075
Messages
6,128,665
Members
449,462
Latest member
Chislobog

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top