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

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You must log in or register to reply here.

Similar threads

C
  • Solved
Disable a Macro
Replies
3
Views
169
saboh12617
S
R
  • Solved
Character count on each line within one cell
3 4 5
Replies
40
Views
846
Peter_SSs
Peter_SSs
D
  • Solved
Macro line is red and I don't know why issue
Replies
3
Views
53
saboh12617
S
D
  • Question Question
VBA Download URL and rename file
Replies
6
Views
381
Jeffrey Mahoney
Jeffrey Mahoney
D
  • Solved
Macro to create a PDF of an external excel workbook
2
Replies
10
Views
158
mumps
mumps

Forum statistics

Threads
1,224,801
Messages
6,181,047
Members
453,014
Latest member
Chris258

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