Format a macro button


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?
 
Ad

Advertisements

O

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
 
Ad

Advertisements


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