Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Command Button Problem | Excel Discussion (Misc queries) | |||
Problem with command button name | Excel Discussion (Misc queries) | |||
strange command button problem | Excel Discussion (Misc queries) | |||
Command Button Problem | Excel Programming | |||
Problem with VB running from a command button | Excel Programming |