Deslecting control buttons

[Yoepy]

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.

Please Login or Register  to view this content.

[TMS]

You could probably use a Worksheet Selection Change event handler to store the Target cell in a global range variable every time a cell was selected. Then you could select the stored cell at the end of your button click event handler.

Regards, TMS

[protonLeah]

You didn't post a workbook, so try:

Please Login or Register  to view this content.

[Yoepy]

AppActivate Application.Caption works

[Izandol]

Also if it is Activex button you may set takefocusonclick property to False.

[Yoepy]

Thank you.
I'll try that too.