View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
Jialiang Ge [MSFT] Jialiang Ge [MSFT] is offline
external usenet poster
 
Posts: 118
Default Cancel Click on label control

Hello Adrian,

Thank you for your patience. We find several workarounds for you:

Wordaround 1.

Add the following code into Sheet1

Private Sub Label1_MouseDown(ByVal Button As Integer, ByVal Shift As
Integer, ByVal X As Single, ByVal Y As Single)
Label1.Visible = False
Label1.Visible = True
End Sub

Click event on any control (not necessarily transparent), puts the control
in focus and covers the controls on top of it. The behavior of the label is
by design.
This workaround makes the label flicker a little bit but the image control
is retained on top.

Workaround 2.

We can consider making the click event of the label run the same code as
the click event of the image.

Please have a try and let me know if it works for your situation. Feel free
to let me know if you have any other questions or concerns. We will spare
no effort to help you.

Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.