You can color your macro buttons in 2007 by utilizing the "BackColor" option
on the userform for that button.

"Rickster" wrote:

I have placed a button on my speadsheet from the forms toolbar and have
assigned a macro to it. I can format the text in the button. How do I format
or color in the button's background?