I posted this once before, but unfortunately didn't get an answer, so I am reposting, but will try and re-word so my problem is clearer.
I use control buttons to perform tasks.
After the user clicks a button the cursor remains on the button.
Therefore if the user start typing nothing happens on the spread sheet.
The user has to use the mouse to click back on the spread sheet to start typing.
If they forget and just start typing and hit the "enter" key, the button the cursor was resting on would be entered on - not the data they thought they had typed.
Is there a way to finish the button macro so the cursor finishes back where it was before the button was clicked?
Thank you.
Private Sub MenuHide_Click() If MenuHide.Value = False Then Call Display_menu Range("ButtonHMTeam") = "0" With MenuHide .Caption = "Hide Menu" .ForeColor = &HFF0000 End With End If End Sub
Bookmarks