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

Disable it within the assigned macro

ActiveSheet.Buttons(Application.Caller).Enabled = False


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"pgarcia" <(E-Mail Removed)> wrote in message
news:CEA56C87-2DC5-45CA-92B9-(E-Mail Removed)...
> 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

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

Oh, the command button takes you to another tab/sheet, so that did not work.

"Bob Phillips" wrote:

> Disable it within the assigned macro
>
> ActiveSheet.Buttons(Application.Caller).Enabled = False
>
>
> --
> ---
> HTH
>
> Bob
>
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
>
>
> "pgarcia" <(E-Mail Removed)> wrote in message
> news:CEA56C87-2DC5-45CA-92B9-(E-Mail Removed)...
> > 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
>
>
>

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
>