| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Command button "selected"
Great, that did the trick.
"Dave Peterson" wrote: Are these commandbuttons on a worksheet? Are you using xl97? If you are, then change the .takefocusonclick property to false. This was fixed in xl2k. If you ever use a control that doesn't have that property, you could also add a line to the code: activecell.activate (It'll work with the commandbutton, too.) pgarcia wrote: When you click on a command button, it seem to be selected always and when a user does not know that and they click the enter button, it runs the macro again. How do de-select the command button once it's clicked? Thanks -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a "cell button" to hide selected cells. | Excel Worksheet Functions | |||
| Programming a "Save as..." command button within Excel | Excel Discussion (Misc queries) | |||
| command button and the "enter" and "tab" keys | Excel Programming | |||
| set up a command button or macro for open file to "save as" | Excel Programming | |||
| Making command button code "more flexible" | Excel Programming | |||
Hybrid Mode
