Excel macro runs twice instead of once

brettdj,
When I was first trying this out, I had simply one line of code that was executed to modify a cell when the user pressed the button on the toolbar. I tried setting Application.Events to False but that had no effect; no events should be triggering that would cause the toolbar button to be "clicked" again... oh, and btw: even if I set breakpoints, they aren't hit. The code just activates twice and that's that.

Steiner,
That's what I was thinking, but I was hoping there was a different answer. Yes, I had noticed that my Public Sub with(parameter) wasn't listed in the macro selection thingy... I just thought I'd still be able to run it normally. The "call-subs" really wouldn't work out for me, since there are a bunch of buttons all trying to call just one or two lines of code... I'd be changing a couple lines of code into about twenty or thirty like that, and I like to be able to keep things dynamic (e.g., I could add a button to the toolbar at any time and simply give it a different paramter in the OnAction property whereas I'd have to hard-code all the "call-subs" for every possible parameter I'd want to use. Grr... M$...

If you have something you want to add, brettdj, that perhaps I missed, go ahead... if no one posts by late afternoon I'll probably just give the points to Steiner. Btw, Steiner, I was thinking of giving you a B since you didn't really give me any documentation or anything (which you can still do, if you can find anything) that talks about subs with parameters that would help support any statements. If you think that's unfair, certainly let me know. And post in the other thread so I can give you those points as well.

Thanks,
PtG

>since you didn't really give me any documentation or anything ... about subs with parameters that would help support any statements

What documentation do you think of here? A general documentation of subs with parameters can be found in the VBA-Help (select Sub and press F1).
And since it seems that using subs with params on a toolbar-button is not supposed to work, there won't be too much documentation about that around (at least none I could find). Or what kind of documentation did you have in mind?

One other way for your problem could be to use the ActionControl-property. But this one was already suggested by Suat in the other thread. Even if you can't really use his answer, it's not his fault that MS created bullshit.

So I'd think that you give him the points for the thread he posted in (or ask for a refund if you REALLY NEED these question points) along with some finishing comment so he knows what it's all about (I can't believe I'm advising to give points to someone else instead of me, guess I should visit a doctor ;-))

If I come up with another solution in the next time, I'll post it here.

Attention PAQ viewers!

Please check out http:Q_20666870.html for the real solution to this question. (It will probably be the last post in there, or at least near the end.)