Create a Menu in Excel

Add-in Express™ Support Service
That's what is more important than anything else

Create a Menu in Excel
 
Guest


Guest


Hi

I'm very new to this product and was wondering if it is possible to create a new menu in Excel with the Add-in Express i.e. similiar to File, Edit etc?

If so, can someone give me a pointer in the right direction.

Thanks
Posted 06 Apr, 2005 03:54:31 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi.

There are some examples available on our site (see the HOWTOs section).
You can also download examples here:
http://www.add-in-express.com/projects/excelmenu.zip
http://www.add-in-express.com/projects/excelrange.zip
Posted 06 Apr, 2005 05:09:03 Top
Ross Macintyre




Posts: 2
 Joined: 2005-04-06

Ok, thanks for these however I may being a little thick

I have replicated the setup of the command bar in the excel menu example however I cannot seem to find the flag or piece of code which makes this command bar shown as a menu in Excel.

What am I missing?
Posted 06 Apr, 2005 10:29:16 Top
Sergey Grischenko


Add-in Express team


Posts: 7233
 Joined: 2004-07-05
Hi Ross.

Draw attention to the CommandBarName property of the ADXCommandBar component. It is "Worksheet Menu Bar" for the main menu in Excel.
You can use our built-in scanner to know all names and Ids of controls in Office applications (download here: http://www.add-in-express.com/downloads/controls-scanner.php).
Posted 06 Apr, 2005 19:43:25 Top
Ross Macintyre




Posts: 2
 Joined: 2005-04-06

Ok thanks, works perfectly
Posted 07 Apr, 2005 03:38:10 Top