?
Solved

Excel 2010 Customise RIbbon addin

Posted on 2011-09-22
2
Medium Priority
?
574 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 93

Accepted Solution

by:
Patrick Matthews earned 2000 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

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

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

Microsoft's Excel has many features that most people will never need nor take advantage of.  Conditional formatting is one feature that you may find a necessity once you start using it.
I came across an unsolved Outlook issue and here is my solution.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

601 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