Format a macro button

[Rickster]

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?

 

[om]

Hi Rickster

I doubt if Form buttons can be formatted. Why don't u use activeX buttons
instead of form buttons. Active X buttons are more interactive and you can
change the color of these buttons by changing the backcolor property. Simply
place a command button in your sheet from Visal Basic toolbox, say the button
is CommandButton1. Double the button and place your macro
------------------------------------------
Private Sub CommandButton1_Click()

'Place your macro here

End Sub

 

[RidgeView]

You can color your macro buttons in 2007 by utilizing the "BackColor" option