Passing Parameters through OnAction

[Mark Bigelow]

I have an add-in that adds a popup to the Tools menu button. When the
user clicks, they are presented with five buttons on the popup. One of
the buttons needs to pass a parameter to the function it calls. It has
been doing this perfectly for the past month (when it was designed). It
stopped working about three days ago, when the IS people reinstalled
Excel, due to a separate bug. What is going on?

TIA,
Mark

 

[Tom Ogilvy]

What version of Excel. My understanding is that Excel 2002 broke this
undocumented functionality. Perhaps it was restored in one of the SP's - so
maybe they need to get you back up to the same service pack. (I assume you
remained in the same major version of Excel across IS intervention).

 

[mjbigelow]

I'm using version 2000, SP-3. That may be the problem, because before
the change I was using SP-2. Any way around that?

Mark

 

[Tom Ogilvy]

Not that I am aware of.

Depends on what you are actually doing. If you just need to know which
button

CommandBars.ActionControl

Beyond that, I could say how you could set the parameter unless you on
action to an intermediate macro that sets a global variable or something.
There is also the tag property - but, again, not knowing what you are trying
to accomplish or what the circumstances are, can't say what might be
practical.

Regards,
Tom Ogilvy