Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"De"-select a forms control programmatically
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
=EMBED("Forms.CheckBox.1","") | Excel Programming | |||
"Control" plus "click" doesn't allow me to select multiple cells | New Users to Excel | |||
Scroll Bar missing "Control" tab in "Format Properties" dialog box | Excel Discussion (Misc queries) | |||
How to programmatically control "Vary colors by point" | Excel Programming | |||
Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming |