Discussion:
Excel Addins Menu Addition
(too old to reply)
naren
2007-01-09 09:36:16 UTC
Permalink
I have two addins that create custom menu in the excel menu bar
i want one of the menu to sit in another menu if that menu already exists in
excel menu bar
Can i have the information or help to achieve this please

The Scenario,
I wrote code to check for the existence of the Menu1(Which was created by
First Addins) in Workbook_open event in the second Addins
if it finds Menu1, i want the Menu2 of second addins to come under the
Menu1, i tried by finding the control and trying to add under it but it
fails
Regards
Naren
Cindy M.
2007-01-11 18:53:05 UTC
Permalink
Hi Naren,
Post by naren
I have two addins that create custom menu in the excel menu bar
i want one of the menu to sit in another menu if that menu already exists in
excel menu bar
Can i have the information or help to achieve this please
The Scenario,
I wrote code to check for the existence of the Menu1(Which was created by
First Addins) in Workbook_open event in the second Addins
if it finds Menu1, i want the Menu2 of second addins to come under the
Menu1, i tried by finding the control and trying to add under it but it
fails
OK, so you find the first menu, and I'm assuming you can assign it to an
object variable of the type CommandBarButtonPopup?

Then you should be able to ADD another CommandBarButtonPopup control to that,
then add the CommandBarButton controls to that.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
naren
2007-01-22 06:35:38 UTC
Permalink
HI
Thanks a lot for reply, but the actual scenario is, two menus are created by
two independent add-ins,
Post by Cindy M.
Hi Naren,
Post by naren
I have two addins that create custom menu in the excel menu bar
i want one of the menu to sit in another menu if that menu already exists in
excel menu bar
Can i have the information or help to achieve this please
The Scenario,
I wrote code to check for the existence of the Menu1(Which was created by
First Addins) in Workbook_open event in the second Addins
if it finds Menu1, i want the Menu2 of second addins to come under the
Menu1, i tried by finding the control and trying to add under it but it
fails
OK, so you find the first menu, and I'm assuming you can assign it to an
object variable of the type CommandBarButtonPopup?
Then you should be able to ADD another CommandBarButtonPopup control to that,
then add the CommandBarButton controls to that.
Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org
This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)
Loading...