Changing Form Button Background Color

W

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

Jim Thomlinson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top