ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Transparent button (https://www.excelbanter.com/excel-programming/403982-transparent-button.html)

Steve[_100_]

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




Incidental

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


Steve[_101_]

Transparent button
 
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


---
avast! Antivirus: Outbound message clean.
Virus Database (VPS): 080109-0, 09/01/2008
Tested on: 10/01/2008 12:26:55
avast! - copyright (c) 1988-2008 ALWIL Software.
http://www.avast.com




Peter T

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



Incidental

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

Steve[_102_]

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





All times are GMT +1. The time now is 07:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com