I have a highly customized Tab and QAT that I want to share with some of my coworkers. I exported my customizations, and made a copy of my Personal, unlocked for them. I then signed on to another machine, and imported and trimmed down some of the customization and my Personal (they don't need all of my tools).
For my first user, I exported her customzations in case we wanted to roll back. She didn't have a Personal to replace, so I copied mine into her AppData/Roaming/Microsoft/Excel/XLStart folder.
When I fired everything up, she had access to all my buttons on the QAT and my custom tab, but all the paths for the verious macros pointed to MY user name, not hers.
I noticed it first with the QAT, so redid each button to point at her PERSONAL, but would rather not do that with the Custom Tab.
Is there a Faster/Easier way?
Any help is greatly appreciated.
BTW, I also have an Add-In that my users use, based on Ron DeBruin's "MyAddin", that appears in the QAT. The macros mentioned above work best from a custom ribbon tab or the QAT, so I didn't add them to my addin. I don't have access to VB, just VBA, so don't know that I can make a custom tab with an add-in, hence my attempt at a workaround.
Bookmarks