Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Command Button Visibility Problem

Whenever a Command button (or other OLE object) with backstyle set to 'transparent' is clicked it immediately becomes opaque. I've been getting around this problem by setting the button visibility to false and then true in the mousedown handler which does return it to a transparent state, but also prevents activation of the mouseup handler. Any ideas how to keep the button transparent (re-applying backstyle doesn't work)??

Tx

Ian
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Command Button Visibility Problem

Couple of things to try :-
1. First line of click code (to remove button focus)
Activesheet.Range("A1").Select
2. Do you have the property option to take focus on mouse click ?
If so set to False.


---
Message posted from http://www.ExcelForum.com/

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7
Default Command Button Visibility Problem

No luck Brian, but thanks for trying. I assume it's a Microsoft Bug, and that very few people use transparent buttons.
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
Command Button Problem albertmb Excel Discussion (Misc queries) 6 June 22nd 08 01:06 PM
Problem with command button name Jason[_9_] Excel Discussion (Misc queries) 10 October 19th 07 09:54 PM
strange command button problem David Excel Discussion (Misc queries) 0 March 20th 06 03:06 PM
Command Button Problem del Excel Programming 3 November 21st 03 05:13 PM
Problem with VB running from a command button Tim Marsh[_2_] Excel Programming 3 July 31st 03 11:14 AM


All times are GMT +1. The time now is 08:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"