[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Save Custom Ribbon to a Workbook.

Posted on 2012-08-22
Medium Priority
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
  • 2
  • 2
LVL 85

Expert Comment

by:Rory Archibald
ID: 38323847
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

ID: 38329462
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

Rory Archibald earned 1200 total points
ID: 38329723
In that case you will need to alter the customui.xml part of the workbook. See Ron's pages here: www.rondebruin.nl/ribbon.html

Author Closing Comment

ID: 38390797
This was very helpful.  thank you.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

834 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