LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 43
Default change the command button backcolor in Excel 2007?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
change the face color of an Excel command button Chris Leah Excel Discussion (Misc queries) 5 April 21st 23 09:03 AM
Command Button Excel 2007 dhstein Excel Discussion (Misc queries) 4 February 15th 09 04:14 PM
Change from a Command Button to a Form Button Ben in CA[_2_] Excel Programming 4 December 11th 08 10:05 PM
I can't find the command button control object in Excel 2007 Raas Excel Discussion (Misc queries) 4 April 2nd 07 03:46 PM
Changing BackColor on Command Buttons? RBee Excel Discussion (Misc queries) 1 August 30th 06 02:32 AM


All times are GMT +1. The time now is 06:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"