Joseph Poon
Posts: 15
Joined: 2007-06-17
|
Quoted from the Development Guide is:
Add a BuiltinControlConnector onto ADXAddinModule. Set its Id property to the command bar control ID from your host application. To connect the component to the command bar control, leave its CommandBar property empty. To connect the component to the control on a given toolbar, specify the toolbar in the CommandBar property. To override the default action of the control, use the Action event. The component traces the context and when the context changes, it reconnects to the currently active instance of the command bar control with the given Id taking away this task from you.
1) Trying to modify the 'Open (ID =23)' control default action.
2) Followed the message above, setting the BuildinControlConnector 'ID' property to 23.
3) Leaving the 'CommandBar' property to NONE
4) Setting the 'DisableDefaultAction' property to True.
5) Compiled and registered the addin for Excel in VS2005.
6) The 'Open' control's action on the 'Standard' toolbar was modiified.
7) The 'Open' control's action on the 'Worksheet Menu Bar/File' was NOT modified.
Did I miss anything?
|
|
Sergey Grischenko
Add-in Express team
Posts: 7233
Joined: 2004-07-05
|
Hi Joseph.
In this case you should set the CommandBar property of the first built-in connector to the 'Standard' command bar and in the second connector it should be a reference to the 'Worksheet Menu Bar' component.
P.S. We always do our best to answer your forum requests as soon as possible. However, we apply the rule "first in first out" with Premium Support Service subscribers taking priority. Please understand it may take us some time to do research on the issue. Please be assured we will let you know as soon as the best possible solution is found.
|
|
Joseph Poon
Posts: 15
Joined: 2007-06-17
|
Sergey,
I could not change the CommandBar property. This property is a dropdown combo box for selection only. |
|
Sergey Grischenko
Add-in Express team
Posts: 7233
Joined: 2004-07-05
|
Right. Now you need to add two command bars named 'Standard' and 'Worksheet Menu Bar' and use them in the CommandBar property of built-in controls. |
|
Joseph Poon
Posts: 15
Joined: 2007-06-17
|
Thanks Sergey.
What does that ActionEx event do? |
|
Sergey Grischenko
Add-in Express team
Posts: 7233
Joined: 2004-07-05
|
The ActionEx event works in the same way as the Action event but it has the Cancel argument in addition.
|
|