Solution: Prevent Invisible Label Showing Background Color When Clicked

[Jeffrey Mahoney]

This is a solution.

I use a label on a sheet to detect mouse move commands so I can control a shape size. My problem is that even though the label backstyle property is set to invisible, a user can click on it and temporarily cause it to display the backcolor until the mouse is moved from the label. Annoying!

To prevent that, set the label to Enabled in the properties to allow events to get the the VBA project. Add similar code to your label events:

Private Sub CollapseHover_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
CollapseHover.visible = False
  CollapseHover.visible = True
End Sub

Jeff

 

[iliace]

Thanks for the pro tip!