vba Excel Workbook Open 事件来自加载项？

Excel Workbook Open event from within an addin?

提问by Austin

I am trying to trigger a macro to run when an Excel document is opened.

我试图在打开 Excel 文档时触发宏运行。

The problem I am running into is that all of my code resides within an Excel add-in. The Workbook_Open event doesn't work because I can't put the code in individual documents, I need it to reside in the add-in and run whenever any document is opened.

我遇到的问题是我的所有代码都驻留在 Excel 加载项中。Workbook_Open 事件不起作用，因为我无法将代码放入单个文档中，我需要它驻留在加载项中并在打开任何文档时运行。

Is there a way to modify the Workbook_Open event or is there another way to trigger a macro when a different document is opened?

有没有办法修改 Workbook_Open 事件，或者有没有另一种方法在打开不同的文档时触发宏？

回答by Charles Williams

You need to use an Application event. There is a good writeup on how to do this at Chip Pearson's site here.

您需要使用应用程序事件。这里是如何做到这一点的芯片皮尔逊的网站一个很好的书面记录在这里。