form button question

[dorre]

Bon jour

can form buttons be colored? made visible/not visible, etc. I can't find
where these properties are.

Thanks Dorre

 

[tr00per]

Dorre,

Are you talking about a CommandButton? If so....Yes, CommandButtons
have properties: BackColor, Visible, etc. Read about the properties of
CommandButtons in Microsoft Visual Basic Help under: CommandButton
Control.

 

[avveerkar]

One suggestion is to import gif or tiff image on your sheet and assign
macro to it so that it can be used as button. There are many free we
sites where you can get beautiful buttons to import. Eg o
http://www.coolarchive.com/buttonmaker.php you can design your ow
buttons and then import them on your sheet. You will have very elegan
looking worksheet. Try it. It is really cool with excellent colors
caption fonts etc.

If you want button on a tool bar then you can use EXCEL's own Butto
Editor which offers you a 16x16 grid to paint your own button. ( Righ
click anywhere on a tool bar> select customise, select command tab o
"customise menu", select macros category, drag custom button ( yello
smilee) on any tool bar, right click on this button ( with customis
menu still open - dont close it ) and select edit button image.
A V Veerka

 

[dorre]

no, i'm talking about buttons from the forms toolbar.

 

[Tom Ogilvy]

You can change the font color, but I believe the color of the button is
controlled by the windows settings.