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_SheetActivate(Object) | assign command buttons anew with each change of sheets |
| 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 |
 | assignHandler(Object) | assign click handlers to command buttons in passed sheet Sh, maximum 10 buttons are supported |
| AutoClose() | AutoClose cleans up after finishing addin |
| AutoOpen() | connect to Excel when opening Addin |
| cb0_Click() | specific click handler for the 10th definable command button |
| cb1_Click() | specific click handler for the 1st definable command button |
| cb2_Click() | specific click handler for the 2nd definable command button |
| cb3_Click() | specific click handler for the 3rd definable command button |
| cb4_Click() | specific click handler for the 4th definable command button |
| cb5_Click() | specific click handler for the 5th definable command button |
| cb6_Click() | specific click handler for the 6th definable command button |
| cb7_Click() | specific click handler for the 7th definable command button |
| cb8_Click() | specific click handler for the 8th definable command button |
| cb9_Click() | specific click handler for the 9th definable command button |
| cbClick(String) | common click handler for all command buttons |
 | Finalize() | used for releasing com objects |
| 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 |