<div>
Shell &quot;C:\Program Files\Microsoft Office\Office\WINWORD.EXE /yourmacroname&quot;, 1
</div>


Shell "C:\Program Files\Microsoft Office\Office\WINWORD.EXE /yourmacroname", 1

<div>
Hi vbWayne,<br />
&nbsp; &nbsp; Thanks for the help, but I'm sorry, I wasn't specific enough with my question.<br />
<br />
&nbsp; &nbsp; &nbsp;I've got a conrol button on one worksheet, and I want to run a macro within the same file on a different worksheet. &nbsp;Does the line of code require to have &quot;C:\Program Files\...etc?&quot;<br />
&nbsp; Is there there a command/code more specific in excel? 
</div>


Hi vbWayne,
    Thanks for the help, but I'm sorry, I wasn't specific enough with my question.

     I've got a conrol button on one worksheet, and I want to run a macro within the same file on a different worksheet.  Does the line of code require to have "C:\Program Files\...etc?"
  Is there there a command/code more specific in excel?

<div>
 &nbsp; <br />
not sure on that one..I only have bits of code I've collected here and there..the code I gave you opens excel, a file, and runs a macro.<br />
<br />
<br />

</div>


 
not sure on that one..I only have bits of code I've collected here and there..the code I gave you opens excel, a file, and runs a macro.




<div>
andyclap,<br />
<br />
&nbsp; &nbsp; Thanks so much for your knowledge!<br />
It helped me a lot.<br />
<br />
Take Care,<br />
<br />
mlouie23
</div>


andyclap,

    Thanks so much for your knowledge!
It helped me a lot.

Take Care,

mlouie23

<div>
<div class="content wysiwyg-content">
What is the code for clicking on a control button in excel that runs a macro?
</div>
</div>


What is the code for clicking on a control button in excel that runs a macro?

Macros set to a control button

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.