Solved

Excel 2010 Customise RIbbon addin

Posted on 2011-09-22
2
544 Views
Last Modified: 2012-05-12
Hi Experts

I have an excel add-in, on my local pc I have customised the ribbon to launch a maco contained in the add-in, the problem is that when I use the add-in on another machine, the customised ribbon is lost, I use to be able to program the command toolbars in pre Excel 2007 but now believe I have to edit some XML contained with in the actual Excel file (Excel 2007 post are actually zip files) , does anyone have a good guide on how to customise the ribbon add-in or any advice?

Please note I cannot use VSTO. The customisation of the ribbon must be done via the XML file.
0
Comment
Question by:MrDavidThorn
2 Comments
 
LVL 92

Accepted Solution

by:
Patrick Matthews earned 500 total points
ID: 36580801
>>I use to be able to program the command toolbars in pre Excel 2007

Actually, you still can: in Excel 2003 I very often had add-ins or even just regular files add items to the Worksheet Menu Bar.  In Excel 2007/2010, the CommandBars object model still exists; it adds the menu structures in the Add-Ins tab of the Ribbon.

:)
0
 

Author Comment

by:MrDavidThorn
ID: 36580920
That is true I just wanted to insert an icon into a another tab /group I found a  freeware app called Custom UI editor, this works a treat!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question