<div>
This example code will work for me. Thanks for the example. &nbsp;<br />
I think Norie is saying the same thing, so I gave credit for the answer too.
</div>


This example code will work for me. Thanks for the example.  
I think Norie is saying the same thing, so I gave credit for the answer too.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
I want to run the same macro assigned to CommandButton21 located on Sheet5 from a new, second CommandButton2 on Sheet 5. &nbsp;Is there a way to &quot;call&quot; the macro without having to repeat (copy) the macro routine for the second CommandButton2? &nbsp;Because the button toggles colors and changes text each time invoked, I don't want a solution using a shape.<br />
Berry
</div>
</div>


Hello Experts,
I want to run the same macro assigned to CommandButton21 located on Sheet5 from a new, second CommandButton2 on Sheet 5.  Is there a way to "call" the macro without having to repeat (copy) the macro routine for the second CommandButton2?  Because the button toggles colors and changes text each time invoked, I don't want a solution using a shape.
Berry

How to run the same macro from two ActiveX CommandButtons

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.