Open AVHuntley opened 1 year ago
Removed in-cell drop downs Removed sheets supporting drop-downs Disabled SheetChange VBA event Locked All format rows, all columns (grid is not write-enabled).
Conditional formatting cleared and template Reset to speed up IR build.
This model uses VBA for validation and for adding subtotals to the transactions sheet.
A3Modeling_AfterDataSetTransactionQuery
- seems to work as intendedWorkbook_SheetChange
- not sure?