Macros for Quick Access Toolbar - Where to Save Macros

[scottjschultz]

I've created a few macros for formatting that I like and saved them to a file. I assigned buttons to the macros in the Quick Access Toolbar, but every time I use one of the buttons, it opens the source file with the Macros. How do I get the Macros in the Quick Access Toolbar to work without having to have the Excel file open that has the macros saved in it?

 

[6StringJazzer]

The typical solution for this is to use PERSONAL.xlsb which is always open and hidden.