View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Command button "selected"

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