Hi all,
I have a project that features macros that are activated by buttons in the QAT. There's only four of them and they're much less ugly that buttons on the worksheet itself. They're saved to the worksheet (when you set them up i forget what the options are but its something like all worksheets or this specific document). Having the QAT follow me from device to device is great. But is there a way to import this QAT for when another user accesses the document? I know it can be imported manually but I was hoping there's a VBA way of importing the QAT on open if its a different user (and maybe removing it on close?).
Thanks!
I have a project that features macros that are activated by buttons in the QAT. There's only four of them and they're much less ugly that buttons on the worksheet itself. They're saved to the worksheet (when you set them up i forget what the options are but its something like all worksheets or this specific document). Having the QAT follow me from device to device is great. But is there a way to import this QAT for when another user accesses the document? I know it can be imported manually but I was hoping there's a VBA way of importing the QAT on open if its a different user (and maybe removing it on close?).
Thanks!