Excel Events
link - docs.microsoft.com/en-us/office/dev/add-ins/excel/excel-add-ins-events
enumeration - Excel.EventType.tableAdded - etc
| Chart | onActivated | (1.8) |
| onAdded | ||
| onDeactivated | (1.8) | |
| onDeleted | ||
| ChartCollection | onActivated | (1.8) |
| onAdded | (1.8) | |
| onDeactivated | (1.8) | |
| onDeleted | (1.8) | |
| Binding ? | onDataChanged | (1.9) |
| onSelectionChanged | (1.9) | |
| SettingCollection ? | onSettingsChanged | |
| Shape | onActivated | (1.9) |
| onDeactivated | (1.9) | |
| Table | onChanged | Occurs when data changes on a specific table. (1.7) |
| onFiltered | (beta) | |
| onSelectionChanged | Occurs when the selection changed on a specific table. (1.7) | |
| TableCollection | onAdded | (1.9) |
| onChanged | Occurs when data is changed on any table in a workbook, or a worksheet. (1.7) | |
| onDeleted | (1.9) | |
| onFiltered | (beta) | |
| Workbook | onAutoSaveSettingChanged | Occurs when the AutoSave setting is changed on the workbook. (1.9) |
| onSelectionChanged | Occurs when the selection in the document is changed. (1.2) | |
| Worksheet | onActivated | Occurs when the worksheet is activated. (1.7) |
| onCalculated | Occurs when the worksheet has finished calculation. (1.8) | |
| onChanged | Occurs when data changed on a specific worksheet. (1.7) | |
| onColumnSorted | Occurs when one or more columns have been sorted. (1.10) | |
| onDeactivated | Occurs when the worksheet is deactivated. (1.7) | |
| onFiltered | Occurs when filter is applied on a specific worksheet. (beta) | |
| onFormatChanged | Occurs when format changed on a specific worksheet. (1.9) | |
| onRowHiddenChanged | Occurs when the hidden state of one or more rows has changed on a specific worksheet. (beta) | |
| onRowSorted | Occurs when one or more rows have been sorted. (1.10) | |
| onSelectionChanged | Occurs when the selection changed on a specific worksheet. (1.7) | |
| onSingleClicked | Occurs when a left-clicked/tapped action happens in the worksheet. (1.10) | |
| WorksheetCollection | onActivated | Occurs when any worksheet in the workbook is activated. (1.7) |
| onAdded | Occurs when a new worksheet is added to the workbook. (1.7) | |
| onCalculated | Occurs when all the worksheets in the collection have finished calculation. (1.8) | |
| onChanged | Occurs when any worksheet in the workbook is changed. (1.9) | |
| onColumnSorted | Occurs when one or more columns have been sorted. (1.10) | |
| onDeactivated | Occurs when any worksheet in the workbook is deactivated. (1.7) | |
| onDeleted | Occurs when a worksheet is deleted from the workbook. (1.7) | |
| onFiltered | Occurs when any worksheet's filter is applied in the workbook. (beta) | |
| onFormatChanged | Occurs when any worksheet in the workbook has format changed. (1.9) | |
| onRowHiddenChanged | Occurs when the hidden state of one or more rows has changed on a specific worksheet. (beta) | |
| onRowSorted | Occurs when one or more rows have been sorted. (1.10) | |
| onSelectionChanged | Occurs when the selection changes on any worksheet. (1.9) | |
| onSingleClicked | Occurs when left-clicked/tapped operation happens in the worksheet collection. (1.10) |
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext