应用程序对象事件

   

创建或打开工作簿时,任意打开的工作簿中的任意工作表发生更改时,或者创建或打开任意数据透视表时,将引发应用程序事件。若要编写 Application 对象的事件过程,必须在类模块中用 WithEvents 关键字创建新的对象。有关详细信息,请参阅应用程序对象事件的用法

NewWorkbook

SheetActivate

SheetBeforeDoubleClick

SheetBeforeRightClick

SheetCalculate

SheetChange

SheetDeactivate

SheetFollowHyperlink

SheetSelectionChange

SheetPivotTableUpdate

WindowActivate

WindowDeactivate

WindowResize

WorkbookActivate

WorkbookAddinInstall

WorkbookAddinUninstall

WorkbookBeforeClose

WorkbookBeforePrint

WorkbookBeforeSave

WorkbookDeactivate

WorkbookNewSheet

WorkbookOpen

WorkbookPivotTableCloseConnection

WorkbookPivotTableOpenConnection