Save Custom Ribbon to a Workbook.

Posted on 2012-08-22
Last Modified: 2012-09-12
I have a macro that i would like to attach to a button.  But this button does not need to be available for all excel workbook.  Is there a way to associate a custom Ribbon to a Workbook?
Question by:PLA_LTM
    LVL 85

    Expert Comment

    by:Rory Archibald
    Which version of Excel are you using? Also, does it have to be on the Ribbon or is the Quick Access Toolbar OK?

    Author Comment

    The version is Excel 2010.
    Quick access toolbar would be OK, but it should only be available to this particular workbook and all other toolbars/ribbons should be disabled.

    The ideal solution would be to this custom ribbon active and all other ribbons hidden/invisible and available to only this particular workbook
    LVL 85

    Accepted Solution

    In that case you will need to alter the customui.xml part of the workbook. See Ron's pages here:

    Author Closing Comment

    This was very helpful.  thank you.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Sometimes we don't want to show zeros in our Excel spreadsheets. This is sometimes most evident in our charts. Look at the chart below, all the zero values are visible. I think that all will agree with the fact that zero values are not looking nice …
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    728 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

    15 Experts available now in Live!

    Get 1:1 Help Now