Macro button colour change???

B

Beefyme

How can you change the colour of a button (one that you create when using a
macro). I can change the text colour but not the actual button colour. I have
the microsoft office 2003 (which i think is the latest). Thanks, hope someone
can help.
 
T

tjtjjtjt

Where di you insert the button to? Is it on a Toolbar? On the Spreadhseet? If
it's on the Spreadsheet, did you use the Forms Toolbar or the Control Toolbox?

If on a Toolbar, you can choose modify from the Customize Dialog with your
button Selected.

If on the Spreadsheet and created from the Control Toolbox, you can change
the BackColor Property

If on the Spreadsheet and created from the Forms Toolbar, AFAIK, you can't
change the color from within Excel using standard commands.

tj
 

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

Similar Threads

Maintaining Background Colours of Tasks of a Subproject in the Master Project File? 0
How can i put text in a cell depending on colour 0
Command Button- Assign Macro & Sheet Protection problem 1
Conditional format 1
Styles: one personal useful layout 0
Sum macro 2
Can't format 'invert if negative' colour programmitically (macroignores it!) 0
Change the colour of a cell if another named cell is blank 2

Top