Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Parameters through OnAction
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 --- Mark Bigelow mjbigelow at hotmail dot com http://hm.imperialoiltx.com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Parameters through OnAction
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). -- Regards, Tom Ogilvy "Mark Bigelow" wrote in message ... 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 --- Mark Bigelow mjbigelow at hotmail dot com http://hm.imperialoiltx.com *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Parameters through OnAction
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Passing Parameters through OnAction
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 mjbigelow wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Passing several parameters to OnAction property. | Excel Discussion (Misc queries) | |||
OnAction of Menu Bar with variable parameters | Excel Discussion (Misc queries) | |||
Set up OnAction of a Menu Bar button to a function with variable in the parameters | Excel Discussion (Misc queries) | |||
Passing parameters Cel Ref) to Sum function | Excel Discussion (Misc queries) | |||
OnAction | Excel Programming |