QAT中的宏未引用到已保存的工作簿 [英] Macro in QAT not referenced to saved workbook

问题描述

我有一个Excel模板，该模板在快速访问工具栏(QAT)中具有一个宏按钮.当我将模板另存为启用Excel宏的工作簿时，在QAT中找到的按钮将链接回原始模板中的宏，而不是在我刚刚保存的新文件中找到的宏.有没有办法让我在新文件中获得QAT工具栏，以引用已保存文件中的宏而不是原始模板?

I have an excel template that has a macro button in the quick access toolbar (QAT). When I save the template as an Excel Macro Enabled Workbook, the button found in the QAT is linked back to the macro in the original template, not the macro found in the new file I just saved. Is there a way I can get the QAT toolbar in this new file to reference the macro in the saved file instead of original template?

推荐答案

我终于明白了.我只需要为当前文档添加它，而不是为所有文档添加它(默认).与我直觉的想法相反.可能与每个选项存储宏的方式有关.

I figure it out finally. I needed to add it for the current document only, not all documents (default). Opposite of what I intuitively thought. It probably has something to do with how the macros are stored with each option.

这篇关于QAT中的宏未引用到已保存的工作簿的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！