Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Transparent button
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
|
|||
|
|||
Transparent button
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
|
|||
|
|||
Transparent button
"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
|
|||
|
|||
Transparent button
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
|
|||
|
|||
Transparent button
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 | |
|
|
Similar Threads | ||||
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) |