Changing Form Button Background Color

[wrkoch]

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
+-------------------------------------------------------------------

 

[Guest]

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...