Friday, January 11, 2019

The Quick Access Toolbar can refer to macros in a specific document

A long time ago I wrote some macros in an Excel workbook. A user put shortcuts to them in the Quick Access Toolbar. When the workbook was copied, we found that pressing the buttons made Excel open the old copy of the workbook - apparently it was trying to run the macro from the original document. This was confusing because the QAT customization screen referred to the commands as ThisWorkbook.MacroName and even showed the path to the new workbook on mouseover. But deleting the macro entries from the QAT and re-adding them from the new workbook made them work with the new workbook.

No comments:

Post a Comment