"De"-select a forms control programmatically
What's wrong with selecting a cell, eg
ActiveCell.Select
But why are you Select'ing the control in the first place, you don't need to
merely to assign it's LinkCell property
Regards,
Peter T
"H.G. Lamy" wrote in message
...
Hello,
in a short VBA-macro, I have to select a forms control on a worksheet, and
assign a "cell-link" to.
After that, the control should not stay selected, so that the worksheet
user doesn't accidentally delete it.
To that end, right now the last step in my macro is to select a one cell
range, but that doesn't always seem to be the best solution.
I've tried with Sendkeys {Escape}, in vain.
Any idea how to "de-"select a forms control by VBA ?
Thank you in advance.
Regards,
H.G. Lamy
|