Share Quick access toolbar

Posted on 2011-10-05
Last Modified: 2012-08-14

I have created a macro and assigned this to a custom button on the quick access toolbar - the template containing all this is loaded in my startup folder so I can use the button on any document (run the macro that is).
Is there anyway I can share this with other PC's? - I copy the template (.dotm) to another persons startup folder but do I now have to manaully create a quick access button - is there anyway to automate this???
Question by:sbsbats
    LVL 50

    Accepted Solution


    you can export the settings. File > Options > Quick Access Toolbar > Import/Export button at the bottom right corner.

    Save to a file and move to other PC, use the same dialog to import

    cheers, teylyn
    LVL 10

    Assisted Solution

    In office 2010 you can export the quick access UI and send that to other ppl.
    They can then import this file and set the Quick Access Bar to whatever was set in the UI file

    Apart from finding a long winded SendKeys to do that, I can't think of anything else atm.

    Author Comment

    Hi Guys,

    I want to automate this process without having to import - import creates a *.exportedUI file that I assume is converted upon the import.
    If I can find the location of my Word.officeUI file this will contain all the customizations I have done? then I can write a script to overwrite a users existing file.

    Just need to find it now - anyone tell me where this is loacted.
    LVL 21
    What is a user has already made custom changes the the QAT.? I would recommend not overwriting but add it to the existing.

    Author Comment

    Yip good call - by the looks the file is not there by default but created when you create a customization?

    Not worried about overwriting any existing settings as this will be rolled out when i installed Office 2010 anyway - would prefer to be able to customize myself.

    Author Comment

    Thanks guys - found the Word.officeUI in my appData folder and copied this to other users

    Author Closing Comment


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
    My experience with Windows 10 over a one year period and suggestions for smooth operation
    This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.
    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…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now