View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
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