View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy[_2_] Patrick Molloy[_2_] is offline
external usenet poster
 
Posts: 1,298
Default Label control - suppress GetFocus

that's a nice solution & works well.

I added this to the sheet code
Private Sub Label2_Click()
Label2.SendToBack
End Sub

now, as soon as you move off the label behind the button, the button
re-appears

"Peter Davey" wrote:

G'day all,
I have some embedded command buttons in a worksheet. I want to emulate
'tool tip' functionality. I've been able to do this using the MouseMove
event so that text is diplayed in a label control when the mouse is
moved over one of the buttons. To suppress the tool tip when the mouse
moves off a button, I've position a single label control behind the
buttons and use the MouseMove event for that control to hide the tool
tip label.

This all works beautifully BUT if I click on the background label it
takes the focus and hides the buttons even though the Enabled property
is set to false and backstyle is set to transparent.

Does anybody know how I can stop it taking the focus? I'm doing this at
home at the moment on Excel97 but it will be used at work in Excel2K.

Any replies will be greatly appreciated.

cheers
peterDavey