Macros do not work when transferred to QAT

[DougieJLockhart]

I have a workbook containing about a dozen macros. Originally these were called by clicking buttons on a worksheet and everything worked as expected. I decided to call the macros from the QAT, so that the buttons were always visible no matter where the user was in the workbook. However, Excel seems to lose its mind - I have no idea what code is executed when the button in the QAT is clicked, but it isn't the associated macro. Excel blunders off and starts loading other workbooks. By putting a break on the first line of the macro, I can confirm that it is not called by clicking its icon in the QAT. If I invoke the macro with 'Macro/Run' on the Developer tab, it performs as expected. Is this a known problem with Excel? I suspect it may be related to ribbon customisations not being saved with the workbook.

[DougieJLockhart]

Just in case anyone else gets this problem, it does seem to be associated with the way Excel saves QAT customisations - the customisation contains a reference to the workbook where it was created, and cannot be imported to another workbook (as MS documentation suggests). Safest practice: don't use QAT customisations for a workbook that you will need to distribute to other users.