AddInEvents Methods
The AddInEvents type exposes the following members.
Methods
| Name | Summary | |
|---|---|---|
 | Application_AfterCalculate() | use Application_AfterCalculate to overcome the problem of auto-fitting formula ranges AFTER calculation (final column width is not available in dblistfetchAction procedure) |
| Application_SheetBeforeRightClick(Object, Range, ref Boolean) | Additionally to statically defined context menu in Ribbon this is needed to handle the dynamically displayed CUD DBMapper context menu entries (insert/delete) |
| Application_SheetChange(Object, Range) | Event Procedure needed for CUD DBMappers to capture changes/insertions and set U/D Flag |
| Application_WorkbookActivate(Workbook) | gets defined named ranges for DBMapper invocation in the current workbook after activation and updates Ribbon with it |
| Application_WorkbookBeforeClose(Workbook, ref Boolean) | Clean up after closing workbook, only set flag here, the actual cleanup is only done if workbook is really closed (in WB_Deactivate event) |
| Application_WorkbookDeactivate(Workbook) | Actually clean up after closing workbook |
| Application_WorkbookOpen(Workbook) | reset query cache, refresh DB functions and repair legacy functions if existing |
| Application_WorkbookSave(Workbook, Boolean, ref Boolean) | saves defined DBMaps (depending on configuration), also used to remove contents of DBListfunction results (data safety/space consumption) choosing functions for removal of target data is done with custom doc-properties |
 | AutoClose() | AutoClose cleans up after finishing addin |
| AutoOpen() | connect to Excel when opening Addin |
| cleanupHandlers() | COM cleanup for query table objects and command buttons inside their handlers |
 | Finalize() | used for releasing com objects |
| InitializeCBHandlers(Object) | assign click handlers to command buttons in passed workbook Wb |
| InitializeQueryHandlers(Workbook) | initialize query handlers inside list objects for workbook wb, needed for catching refresh event to avoid sheetchange event execution |
| mDeleteButton_Click(CommandBarButton, ref Boolean) | dynamic context menu item delete: delete row in CUD Style DBMappers |
| mInsertButton_Click(CommandBarButton, ref Boolean) | dynamic context menu item insert: insert row in CUD Style DBMappers |