[Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4313
  • Last Modified:

How to add a menu bar in Excel 2007 ribbon?


I'm just beggining to use the Visual Studio 2005 Tools for the Microsoft Office System, and I've tested to add a menubar to the ribbon of Excel 2007, but it doesn't seem to work.

I don't have any error message, and I know that my menu bar has been added when I count items, but nothing appears.

Any idea?

Thanks by advance,
Excel.MenuBar bar =  Application.MenuBars.Add("Menu 2007");

Open in new window

  • 2
1 Solution
JulienVanAuthor Commented:
I've seen a tutorial that uses a VSTO project "Other Project Types->Extensibility->Shared Add-in" to add a menu in the ribbon.
Do you think that it's the only way to do this (I was trying to customize the ribbon in a standard VSTO Excel add-in)?
You should be able to use a standard VSTO Excel add-in.  You should be able to add an new item to the project (call Ribbon support) that you can manipulate to do what you are looking for.  Have a read through this MS tutorial - http://download.microsoft.com/download/5/5/8/55826AC5-FF9A-461D-ABC3-477E9D1829A7/VSTOv3CTPTutorial.doc  
Pages 15-29 should get you going in the right direction.
JulienVanAuthor Commented:
Thanks, I added a ribbon item to my project and configured the xml file, and it worked!

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now