I tried to delete and re-create the PERSONAL.XLSB. If I add a Sub from a new workbook, or an add-in, it works just fine. Update: apparently, only the macros in my PERSONAL.XLSB do not work from the Quick Access Toolbar. I hope someone has dealt with this problem successfully in the past Appreciate any suggestions.
Those don't work either.Ĭustomizing built-in commands works just fine, existing ones and any new ones added. So it's isolated to just one workstation.Īlso, I tried to create a custom ribbon tab, and add macros there.
Then I tried to import the same file on another machine, and it worked there. I exported the toolbar, and examined the XML - appears fine. No new (or old) macros added to the QAT run. I have tried removing and re-adding the buttons, and resetting the toolbar - doesn't work. The macros still work just fine, and in the Customize menu it says the correct path and name for each one. I have a large number of macros, stored in PERSONAL.XLSB, that I have assigned over time to buttons on my quick access toolbar (QAT). Now I am experiencing this issue and it's driving me crazy. I've seen this asked before around the Internet, but did not see any good answers. Excel 2010, Office Pro Plus, Windows 7, everything 32 bit.
