Button - Format

Ben_Holmes

Board Regular
Joined
Mar 30, 2004
Messages
147
Hi,

I am adding buttons to my spreadsheet and assigning macros to them. Is it possible to change the colour of the button?

I can not seem to find any way of doing this.

Any help would be greatly appreciated.

Thanks

Ben
 

Some videos you may like

Excel Facts

Show numbers in thousands?
Use a custom number format of #,##0,K. Each comma after the final 0 will divide the displayed number by another thousand

SteveO59L

Well-known Member
Joined
Apr 21, 2004
Messages
7,896
If your button is from the controls toolbox, one of the properties is "Back Colour". Change the colour there.
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,774
Office Version
  1. 365
Platform
  1. Windows
What sort of button is it - a "Forms" button or a "Command" button?
 

Ben_Holmes

Board Regular
Joined
Mar 30, 2004
Messages
147
Thanks for the Response Steve.

However I seem to be being really stupid because I can not see where I go to change this I have tried right clicking and going to format but their is no option for back colour.

Can anyone tell me how to do this.

Cheers

Ben
 

Ben_Holmes

Board Regular
Joined
Mar 30, 2004
Messages
147

ADVERTISEMENT

It is a forms button.

Thanks

BEn
 

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,774
Office Version
  1. 365
Platform
  1. Windows
Ben
I'm pretty sure you can't easily change the backcolour of a Forms button, as it's controlled by the Windows properties (I think).

My only suggestion is to use a Command button from the Controls toolbox instead, and to get the code into it, right-click it select "View Code" then paste the original code into the Commandbutton_click holder there.

For the colour, right click the button and select properties / backcolor.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,850
Messages
5,598,457
Members
414,239
Latest member
xnanx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top