Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandButton Link to Macro
How do you link a Macro to a CommandButton.
Right now when I click on the button in design mode it references a macro on the worksheet I am working on and it is trying to reference another Macro. The macro is stored in a different file in another directory. What is the file path to reference a Macro somewhere else? So far my code in the commandbutton looks like this, but it doesn't do anything when I click the button. I am missing some part of the path to find the Macro. Can anyone help me? Private Sub File_Updated_Click() Public Sub Fileupdate() End Sub Thank you for your help! Kristina |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandButton Link to Macro
You can run a macro in another file using:
Excel.Run "<file!<macro" where you replace <file with the filename and <macro with the macro name. However, I think the file already needs to be open in Excel, so you will probably need to do that in your code also. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CommandButton Link to Macro
The easiest thing you can do is to
(a) create an object instead of a button within the file you have the macro stored. This can be a rectangle, that looks like a CommandButton, but it is actually a rectangle object. (b) you assign the required macro to this object (c) you then copy and paste the object into the file you want to start the macro from In case the file with the macro is not open when the user hits the pseudo 'button', excel will open the file for the user to run the macro. Hope this is an option, at least it works fine for me in '97. Gabor "KMassey1976" az alábbiakat írta a következo hírüzenetben: ... How do you link a Macro to a CommandButton. Right now when I click on the button in design mode it references a macro on the worksheet I am working on and it is trying to reference another Macro. The macro is stored in a different file in another directory. What is the file path to reference a Macro somewhere else? So far my code in the commandbutton looks like this, but it doesn't do anything when I click the button. I am missing some part of the path to find the Macro. Can anyone help me? Private Sub File_Updated_Click() Public Sub Fileupdate() End Sub Thank you for your help! Kristina |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link embedded chart to a commandbutton? | Charts and Charting in Excel | |||
how do i make a commandbutton run a macro?? | New Users to Excel | |||
Commandbutton in UserForm to run Macro | Excel Programming | |||
Macro won't run from CommandButton | Excel Programming | |||
Code runs different in a commandbutton than a macro why? | Excel Programming |