Excel工作表可以触发事件 [英] Excel sheet can fire an event

问题描述

可以从excel工作表中触发任何事件，例如打开新工作表

it is possible to fire any event from excel sheet like open new sheet

推荐答案

是的，请使用工作簿的Workbook_NewSheet事件(如果未选择，请选择ThisWorkbook (不要重命名)在代码编辑器(ALT + F11)中

您实际上首先需要选择ThisWorkbook，然后在代码窗口的第一个组合框中选择Workbook.之后，可以从包含事件的右侧的组合框中选择事件.

祝你好运！

Yes, use the Workbook_NewSheet event of the Workbook (select ThisWorkbook if you didn''t rename it) in the code editor (ALT+F11)

You really first need to select ThisWorkbook and then select Workbook in the first combobox in the code window. After that the event can be selected from the combobox to the right of that, which holds the events.

Good luck!

这篇关于Excel工作表可以触发事件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！