Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've read all of the posts here - questions and answers - about changing the
color of a macro activation button (command button), but none of them seem to apply to Excel 2007. I don't have a control toolbox, I have a developer tab with a controls group. Using this I can create/insert a command button and assign it to a macro. This causes no problem. I have a need, however, to change the color of several buttons to make some of them more prominent. I can find no properties for BackColor of the command button. In spite of what has been posted here, I CAN change the color of a button I place in a user form - via the BackColor property, but I CANNOT find a similar property for the command buttons I've created. Is this by chance one of those features that has been changed/eliminated/enhanced by Microsoft between Excel 2003 and Excel 2007? If I create a command button in 2003, I can find the field that will edit the color of the button. If, however, I try to open my 2007 file in 2003, I no longer have a backcolor property to edit. I'd really like to be able to change the color of some of these buttons. I currently have two buttons - both uninspiring gray - but my boss has asked to have 16 more buttons created in this sheet. You can see the need for making the primary buttons stand out. Can anyone help me with this in Excel 2007? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change the face color of an Excel command button | Excel Discussion (Misc queries) | |||
Command Button Excel 2007 | Excel Discussion (Misc queries) | |||
Change from a Command Button to a Form Button | Excel Programming | |||
I can't find the command button control object in Excel 2007 | Excel Discussion (Misc queries) | |||
Changing BackColor on Command Buttons? | Excel Discussion (Misc queries) |