CODEWITHSUNDEEP
excelvbaexcel-2007ribbonexcel-2010
intrigued_66
intrigued_66

Reputation: 17240

VBA code to add a basic ribbon in Excel 2010?

I have used products to write ribbons for Excel in C# (addin express) but I need to know how to produce a ribbon using vba. Would someone be able to provide me with some code that inserts an additional ribbon into the toolbar for this?

By ribbon I mean where it says "Formulas", "Data", "Review" etc

Upvotes: 4

Views: 19255

Answers (2)

Jan Wijninckx
Jan Wijninckx

Reputation: 511

There is a simple trick to it - the xml is to be included in your .xlsm file.

See this link How to add a custom Ribbon tab using VBA?

Upvotes: 0

Olle Sjögren
Olle Sjögren

Reputation: 5385

You can customize the ribbon in Excel using a combination of XML and VBA.

A good starting-point for customizing the ribbon: http://msdn.microsoft.com/en-us/library/office/aa338202%28v=office.12%29.aspx (The title says Office 2007 but it will work for Office 2010 as well)

Another good source is the one nutsch mentioned in his comment.

There is also a free application that helps you design and validate the XML to modify the ribbon called the "Custom UI Editor For Microsoft Office": http://openxmldeveloper.org/blog/b/openxmldeveloper/archive/2006/05/25/customuieditor.aspx

Upvotes: 4

Related Questions