Customise Excel 2010 ribbon

Posted on 2011-05-12
Last Modified: 2012-05-11
I have used the ribbon customisation feature of Excel 2010 to add various Excel commands to the ribbon (eg; formatting etc..) and it works well - I am also able to export these customisations, and then import them into Excel on another PC.
Where this does not work is if I create a custom ribbon item which points to a macro (located on my hard drive)

What I would like to do now is to create a very basic Add-In, which will place a menu item on the ribbon which will open a file.
Can anyone provide some sample code for such an Add-In?
Question by:fjkilken
    LVL 85

    Accepted Solution

    I suggest you have a read of Ron's pages here: for the best way to customise the Ribbon.

    Author Closing Comment

    cool - great link - thanks

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
    In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    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…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now