| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Form Button Background Color
Its obvious I'm missing something here. There is no background colo attribute when I right button click on the object. That's why thought I had to get at it from code. I'm probably in the wron view..... See attached +------------------------------------------------------------------- |Filename: TestButton.zip |Download: http://www.excelforum.com/attachment.php?postid=2651 +------------------------------------------------------------------- -- wrkoc ----------------------------------------------------------------------- wrkoch's Profile: http://www.excelforum.com/member.php...fo&userid=1006 View this thread: http://www.excelforum.com/showthread.php?threadid=26180 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Changing Form Button Background Color
It depends where you got the button from as to whether you can change the
colour or not. Oddly enough there are two types of buttons which are good for different purposes. The one you have chosen is probably from the forms toolbar and you can not edit the color of this button (Sorry, but what it is good for is if you need to copy the sheet the button will go with it and will still be attached to the macro). The button you want is off of the ControlBox tool bar. Right click on it and you will get a properties list including back color, etc... This type of button does not copy well with the copying of the sheet as it will no longer be atached to any code in the background.... Hope this helps... "wrkoch" wrote: Its obvious I'm missing something here. There is no background color attribute when I right button click on the object. That's why I thought I had to get at it from code. I'm probably in the wrong view..... See attached. +-------------------------------------------------------------------+ |Filename: TestButton.zip | |Download: http://www.excelforum.com/attachment.php?postid=2651 | +-------------------------------------------------------------------+ -- wrkoch ------------------------------------------------------------------------ wrkoch's Profile: http://www.excelforum.com/member.php...o&userid=10064 View this thread: http://www.excelforum.com/showthread...hreadid=261806 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing background color | Excel Discussion (Misc queries) | |||
| changing cell background color | Excel Worksheet Functions | |||
| background color showing only when in email form | Excel Discussion (Misc queries) | |||
| Need help with Option Button dynamic background color | Excel Discussion (Misc queries) | |||
| Changing Form Button Background Color | Excel Programming | |||
![wrkoch[_8_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
