Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
form button question
Bon jour
can form buttons be colored? made visible/not visible, etc. I can't find where these properties are. Thanks Dorre |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
form button question
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
form button question
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 -- avveerka ----------------------------------------------------------------------- avveerkar's Profile: http://www.excelforum.com/member.php...fo&userid=3033 View this thread: http://www.excelforum.com/showthread.php?threadid=50862 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
form button question
no, i'm talking about buttons from the forms toolbar.
"tr00per" wrote in message oups.com... 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
form button question
You can change the font color, but I believe the color of the button is
controlled by the windows settings. -- Regards, Tom Ogilvy "dorre" wrote in message ... no, i'm talking about buttons from the forms toolbar. "tr00per" wrote in message oups.com... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Form button | Excel Discussion (Misc queries) | |||
Form button question | Excel Programming | |||
Command Button vs Form Button | Excel Programming | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming | |||
Command Button vs Form Button | Excel Programming |