See all How-To Articles

How to Change the Color of ActiveX Control Button in Excel

In this article, you will learn how to change the color of a button in Excel.

 

change button color 5

 

Buttons are used in Excel to call macros. From the Developer tab, you can insert a button and assign it a macro. Then, clicking on that button will run the selected macro. Once you have your button set up, you can change its properties. In a spreadsheet, one easy way to direct attention to a button is to change the button’s colors.

Change the BackColor of an ActiveX Control Button

1. First, be sure that Design Mode (Developer > Controls > Design Mode) is enabled so that you can use the Properties option.
(If you can’t see the Developer tab, customize your Ribbon to add it.)

 

change button color 7

 

2. Select the button whose color you want to change. Then in the Ribbon, go to Developer > Controls > Properties.

 

change button color 1

 

3. After that, the Properties window will open. To change the backcolor of the button, (1) click on Alphabetic to see a list of button properties in alphabetical order. Then (2) select BackColor in the left column, and (3) click on the arrow in the right column to display the color options. Finally, (4) choose a color (from the Palette or System).

 

change button color 2

 

After clicking on the desired color, the color of the button will automatically change. As you can see below, the backcolor of an ActiveX button is the fill color of the shape.

 

change button color 4

 

Change the ForeColor of an ActiveX Control Button

As shown above, the backcolor of a button is its fill color. You can also customize the color of the text on the button by changing the forecolor.

1. To do this, in the Ribbon, go to Developer > Properties.

 

change button color 1

 

2. In the Properties window, (1) click on Alphabetic and (2) select ForeColor. After that, (3) click on the arrow to the right to display the color options, and (4) choose a color from the Palette (or System).

 

change button color 6

 

As a result, the text color (forecolor) of the button will be changed. The transformed button shown below is more easily visible in Excel than the standard gray button with black text.

 

change button color 4 new