Good Afternoon!
I'm struggling... I have a code for certain actions to occur when I hover over the "OctGB" command button... but how to I make it revert those actions when I'm no longer hovering over "OctGB"?
I feel like it should be obvious, but Google is failing me on this one.
Thanks!
----------------------
Private Sub OctGB_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
ActiveSheet.Shapes("OctGB_Chart").ZOrder msoBringToFront
ActiveSheet.OctGB.BackColor = RGB(200, 210, 240)
ActiveSheet.OctGB.Font.Bold = True
ActiveSheet.OctGB.Font.Size = 10
I'm struggling... I have a code for certain actions to occur when I hover over the "OctGB" command button... but how to I make it revert those actions when I'm no longer hovering over "OctGB"?
I feel like it should be obvious, but Google is failing me on this one.
Thanks!
----------------------
Private Sub OctGB_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
ActiveSheet.Shapes("OctGB_Chart").ZOrder msoBringToFront
ActiveSheet.OctGB.BackColor = RGB(200, 210, 240)
ActiveSheet.OctGB.Font.Bold = True
ActiveSheet.OctGB.Font.Size = 10