• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 814
  • Last Modified:

Share Quick access toolbar

Hello,

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???
0
sbsbats
Asked:
sbsbats
2 Solutions
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

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
0
 
bromy2004Commented:
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.
0
 
sbsbatsAuthor Commented:
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.
0
Independent Software Vendors: 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!

 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
What is a user has already made custom changes the the QAT.? I would recommend not overwriting but add it to the existing.
0
 
sbsbatsAuthor Commented:
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.
0
 
sbsbatsAuthor Commented:
Thanks guys - found the Word.officeUI in my appData folder and copied this to other users
0
 
sbsbatsAuthor Commented:
cheers
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now