Excel VBA changing color for CommandButton

vba excel commandbutton
Matthew C picture Matthew C · Feb 20, 2017 · Viewed 33.7k times · Source

I'm having problem with changing colors of my CommandButton. In the spreadsheet I add design button as form or ActiveX.

Then in VBA I try:

Activesheet.shapes("CommandButton1").visible = false

This one works just fine.

But then I try:

Activesheet.shapes.Fill.ForeColor.RGB = RGB(220, 105, 0)

It runs without error but nothing changes; color remains as it was before.

Could you please help me with this?

Answer

pokemon_Man picture pokemon_Man · Feb 20, 2017

Just try it like this:

ActiveSheet.CommandButton1.BackColor = RGB(220, 105, 0)

Related questions

How do you control a button inside a multipage in excel VBA

I have a multipage, I was successfully able to copy elements of the first page which is my reference page to new pages which is created dynamically. My question is, how do I set a commandbutton's actions inside a page …

Read More
How to hide tabs and make them appear after a specific optionbutton is selected?

I posted earlier, but since have made some good progress and figured some stuff out by myself! I have nearly finished my project, but need to make the last real bit of code, then just some general tidying up. What …

Read More
Is there a way to crack the password on an Excel VBA Project?

I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA …

Read More