Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Form button Thor Excel Discussion (Misc queries) 1 May 5th 07 09:37 PM
Form button question Bri[_3_] Excel Programming 5 February 3rd 06 03:59 PM
Command Button vs Form Button Bri[_3_] Excel Programming 2 February 3rd 06 08:18 AM
Pause macro, add form button to sheet, continue macro when button clicked! Flystar[_15_] Excel Programming 1 May 26th 04 09:45 AM
Command Button vs Form Button T K Excel Programming 4 August 26th 03 07:26 PM


All times are GMT +1. The time now is 11:20 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"