Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Assign a Workbook Specific Button to the Quick Access Toolbar

Latest post Thu, Jun 24 2010 5:37 PM by Nick Hodge. 1 replies.
  • Thu, Jun 24 2010 9:00 AM

    • mhunt3
    • Not Ranked
    • Joined on Thu, Jun 24 2010
    • Posts 1
    • Points 21

    Assign a Workbook Specific Button to the Quick Access Toolbar

    I am trying to create a workbook specific button on the quick access toolbar that runs a macro.  I have no problem creating the macro and assigning it as a button on the QAT, but when I close the file and then reopen, the button is no longer there.  I have saved the file with a .xlsm extension.  What do I need to do to make the button avialable on the QAT automatically when I open the specific workbook?  I do not want the button on the toolbar all of the time, just for the specific workbook.
    • Post Points: 21
  • Thu, Jun 24 2010 5:37 PM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 543
    • Points 9,287
    • MVP

    Re: Assign a Workbook Specific Button to the Quick Access Toolbar

    You would only be able to do this using RibbonX inside the file and in that regard you are better to add a new tab. This can be contained in the workbook and so would only be there when the workbook was opened. I use this all the time with tabs for departments, e.g a marketing tab for that team and a sales tab for that team.

    To look at it seems tricky but it's really not that tough.

    Here is my tutorial on building the ribbon using ribbonX

    http://excelusergroup.org/blogs/nickhodge/archive/2008/01/30/ribbon-step-by-step-part-1-file-formats.aspx

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.