Run macro from embedded object

Wingz

New Member
Joined
Mar 5, 2002
Messages
33
Just wondering what the code is to run a designated macro from an embedded button. For example, I have a macro "Calc" written in a module and instead of copying and pasting the code into the Button Click sub, can I write a "trigger" that runs that macro?
Basically > Click Button > Button "calls" the Calc macro (and then any other macros I may want to run) Thanks in advance!
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
hi, to call the calc macro from a button, you need to create a macro with the code
Call Calc
then, assign this macro to the button.
Will
 
Upvote 0
No, I don't want to run the macro from a toolbar button, I want to run it from a coded embedded button.
 
Upvote 0
I want to create a command button on my worksheet. Inside the code of that command button, I want to trigger a macro.

ie.
Private Sub CommandButton1_Click()
"Trigger macro from here"
End Sub
 
Upvote 0
can i ask why it needs to be within the actual button and not a macro connected to the button?
 
Upvote 0
That's just it... I want to know If I am able to call other macros from the code in a command button. This way I can call 2 or 3 macros by just clicking the button I have embedded.
 
Upvote 0

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

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