Format a macro button

  • Thread starter Thread starter Rickster
  • Start date Start date
R

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?
 
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
 
Back
Top