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

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 226
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
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
How do I show 2007 custom Button Images with transparent backgroun JeffreyW Excel Programming 0 December 9th 07 09:13 PM
Button supposed to be transparent but is not when clicked. LaNae Excel Programming 4 October 25th 06 07:05 AM
transparent button on custom commandbar ckoch Excel Programming 3 February 11th 06 07:41 PM
transparent Patko Excel Discussion (Misc queries) 0 January 3rd 06 10:26 PM
Why does Option Button not hold transparent property? ARB Excel Discussion (Misc queries) 1 August 2nd 05 06:47 PM


All times are GMT +1. The time now is 12:51 AM.

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"