Application Object Events

Application events occur when a workbook is created or opened, when any sheet in any open workbook changes or when any PivotTable is created or opened. To write event procedures for the Application object, you must create a new object using the WithEvents keyword in a class module. For more information, see Using Events with the Application Object.