Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hiya
I have serveral buttons that I need to make transparent. I know how to change the colour but there is not an option to make it transparent. Can it be done or do I have to use an image? --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 080109-0, 09/01/2008 Tested on: 10/01/2008 09:13:02 avast! - copyright (c) 1988-2008 ALWIL Software. http://www.avast.com |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Steve
If you just want the button to be transparent you can change the backstyle property to fmBackStyleTransparent in the controls properties panel. Hope this helps you out. Steve |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"Steve" wrote in message
... Incidental wrote in news:b251f17a-6810-46f4- : Hi Steve If you just want the button to be transparent you can change the backstyle property to fmBackStyleTransparent in the controls properties panel. Hope this helps you out. Steve --- avast! Antivirus: Inbound message clean. Virus Database (VPS): 080109-0, 09/01/2008 Tested on: 10/01/2008 12:14:30 avast! - copyright (c) 1988-2008 ALWIL Software. http://www.avast.com Works great! thx I'm surprised you find it works, for me the fmBackStyleTransparent in a Worksheet control does not persist after clicking it, reverts to its opaque backcolor. If later you find the same occurs for you, try assigning a macro to shape, format the shape's Fill to 'no color' to make it transparent. In Autoshapes/Basic shapes there's a double rectangle that can be made to look like a button, format the line colour as well. Regards, Peter T |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Peter T
I just tried it there and was shocked to find this to be true!!! it's very strange, i know it works fine on userforms. I would agree with you that the best option here for Steve would be to just create his own button using shapes. I wonder why the button reverts as on checking the backstyle is still set to 0 after the click event Thanks for the heads up on that one Steve |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Incidental wrote in news:c8dca20c-337a-4275-
: Hi Peter T I just tried it there and was shocked to find this to be true!!! it's very strange, i know it works fine on userforms. I would agree with you that the best option here for Steve would be to just create his own button using shapes. I wonder why the button reverts as on checking the backstyle is still set to 0 after the click event Thanks for the heads up on that one Steve --- avast! Antivirus: Inbound message clean. Virus Database (VPS): 080110-0, 10/01/2008 Tested on: 11/01/2008 07:24:10 avast! - copyright (c) 1988-2008 ALWIL Software. http://www.avast.com I Have taken your advice and used shapes. It does give a better result. Thanks guys!! Steve --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 080110-0, 10/01/2008 Tested on: 11/01/2008 07:26:11 avast! - copyright (c) 1988-2008 ALWIL Software. http://www.avast.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I show 2007 custom Button Images with transparent backgroun | Excel Programming | |||
Button supposed to be transparent but is not when clicked. | Excel Programming | |||
transparent button on custom commandbar | Excel Programming | |||
transparent | Excel Discussion (Misc queries) | |||
Why does Option Button not hold transparent property? | Excel Discussion (Misc queries) |