Change the color of an Excel Macro button?

[Guest]

Can I change the color of Macro Buttons that Excel makes?

 

[Dave Peterson]

If the button is from the control toolbox toolbar, then click on the design mode
icon (on that same toolbar), rightclick on the commandbutton and select
properties. Look for Backcolor.

If the button is from the Forms toolbar, you can change the font--but not the
backcolor.

 

[Guest]

My next question is can I assign a macro recorded in MS Visual Basic to a
button inserted from the Contron Box Toolbar instead of the Forms Toolbar?

Thanks For your Response.
Jeff

 

[Bob Phillips]

Two things.

You don't assign macros to control toolbox buttons, they have a click event
associated with them (which of course can call a macro).

On the question, if you mean can use VB code in a VBA macro, in principle
yes, although you may need to make small changes. If you mean call the
procedure in a VB executable, that is more difficult. You could wrap it all
in a DLL, link that DLL to your VBA project, and call it from there.

--

HTH

RP
(remove nothere from the email address if mailing direct)