[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Excel 2010 Customise RIbbon addin

Posted on 2011-09-22
2
Medium Priority
?
568 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

650 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