Release Notes

Version 2.4

2.4.7 (18 Jul 2010) NEW

Adds Quick Save tool/shortcut that lets you save files quickly without recalculating, regardless of calculation settings.
Adds Check For Dependents tool/shortcut to check if any cells in a selected range are used in the calculation of other cells. A useful tool to prevent inadvertent deletion of precedent cells.

2.4.6

Lets users specify a default error message/value when using Check for Errors on cell formulas, or be prompted for an error message/value.
Adds new tool and shortcut to reposition cell comments and adjust their sizes to fit comments.
Improves performance of the Paintbrush tool, which is now featured more prominently in Excel® 2007.
Improves speed when saving Macabacus settings in the Settings and Hotkey Manager dialogs.
Fixed Smart Precedents/Dependents bug that displayed an error message when attempting to open other add-ins files on some computers.
Fixed Smart Precedents bugs related to formula arrays and defined names.

2.4.5

Improved behavior for applying individual cell borders when more than one cell is selected. Behavior now mimics native Excel® border behavior.
Increase/Decrease Decimals no longer changes the number format of cells when more than one cell is selected and selected cells have different number formats.
Fixed bug in Footnote tool.

2.4.4

The Trace Precedents/Dependents dialog now remembers its previous location, giving you greater control over its positioning.
The Trace Precedents/Dependents dialog now automatically adjusts position to prevent overlapping highlighted cells (Excel® 2007 only).
The Hotkey Manager now includes a button that lets you conveniently give priority to Macabacus shortcuts when other conflicting shortcuts are indescriminately given priority over Macabacus shortcuts upon starting Excel®.

2.4.3

Big improvements to the reliability of Border Cycle that fix issues with the cycle halting unexpectedly in some cases.
When borders in a cycle are equal on all four sides, borders are now applied around the selected range rather than to individual cells within that range.
Improves reliability of individual cell border shortcuts through better recognition/observation of adjacent cell borders.
Now select any color as the Macabacus cell border color (as opposed to the 4 grayscale options available in previous versions).
Fixes a bug that prevented saving customized shortcut keystrokes using the Hotkey Manager in Excel® 2003.

2.4.2

2.4.1

Smart Dependents/Dependents now includes the ability to expand collapsed rows/columns to view hidden precedent/dependent cells.
Smart Precedents/Dependents now automatically navigates to the first precedent/dependent cell, saving a keystroke.
Smart Precedents now processes precedents for TRANSPOSE formulas.
Back by popular demand, the ability to import previously exported settings is restored.
Default number format cycles now include "@_)" in formats with parenthetical negatives to improve alignment.

2.4

Macabacus Macros rebranded as Macabacus Lite in preparation for a full-featured version available soon. Several non-core, infrequently used features/tools have been removed.
Fixes many Undo issues by cutting the AutoColor on Entry feature altogether. AutoColor on Entry will eventually become available in the full-featured version.
Adds number alignment shortcut.
Improves Trace Precedents algorithm to better handle defined names in formulas.
Improves Blue-Black Toggle compatibility with a more diverse set of custom color palettes.
Removes splash screen that interrupted startup of Excel for some users.
Eliminates need to activate product.

2.3.5

Makes several improvements to the functionality and interface of Smart Dependents.
Smart Precedents can now select entire rows/columns when audited formulas contain notation such as "=SUM($5:$6)" and "=SUM($B:B)", for example.
Adds new tool to delete all constant inputs values from worksheets. Potentially useful when starting fresh from a pre-populated model template.

2.3.4

Adds ability for Smart Precedents to access hidden worksheets.
Greatly improves performance and utility of Smart Copy Right/Down.
Fixes potentially long delay upon copying cells or performing other operations on large cell ranges.
Fixes Smart Precedents bug that prevented proper operation when "!", "_", or "." appeared in precedent sheets' names.
Fixes overflow error when deleting a large number of cells.

2.3.3

Adds ability to export/import your Macabacus Macros user settings so that you can easily transfer your customizations between computers.
Adds a cycle to Fill Color Cycle that removes the selected range's fill color once the end of the cycle is reached.
Implements an improved Border Cycle that avoids the use of workbook styles and fixes a related Border Cycle customization bug.
Fixes Smart Precedents bug that prevented navigation to cell ranges when traversing the audited formula.
Fixes bug related to customization of General Number and Currency Cycles that caused the number of decimal places to grow upon cycling.
Fixes bug that prevented the insertion/deletion of single cells.
Fixes intermittent bug that caused Excel® to freeze upon cut/paste (Excel® 2003 only).

2.3.2

Improves Smart Precedents user interface for easier differentiation among listed cell references.
Fixes bug that prevented query table refreshes from an external data source.
Fixes bug that prevented repeating Paste Special actions.

2.3.1

Allows greater customization of number format cycles.
Minimizes screen flicker when AutoColoring cells upon entry.
Fixes bug that prevented row/column insertion using native Excel® controls.
Improves Undo performance and increases the number of actions that can be undone.

2.3

Restores Undo command for most actions (execution of macros typically disables Undo).
New actions and settings for managing cell comments.
Toggle cell references in formulas between absolute and relative.
Updates Error Wrap to use IFERROR (Excel® 2007 only).
Paintbrush now allows you to capture up to 5 different styles and apply them in a cycle.
Allows Paste Formulas Exact/Transpose more than once.
Fixes bugs in Smart Precedents, and makes Smart Precedents/Dependent dialogs resizable.
Expands multiple and percent number format cycles.
Improves overall reliability and performance.

Select colors for your cycle settings from your own custom color palette, or any other color.
Customize your Macabacus shortcut keystrokes with the new Hot Key Manager.
Fixes intermittent problem that prevented opening of files upon first attempt.

Excel® 2007 now kicks it old school with optional Excel® 2003 menus and toolbars (Excel® 2007 only).
Improves performance of Smart Precedents with support for named ranges.
Adds Save As, Sum Bar, and Wrap Text shortcuts, as well as shortcut keystrokes for existing workbook clean-up tools.

More than doubles the number of shortcuts and features found in version 1.4.
Allows users to customize various Macabacus Macros settings.
Adds dynamic AutoColoring of fonts upon data entry and additional AutoColor options.
Adds Power User Setup tool that allows experienced users to quickly set up Excel® for optimal use.
Greatly improves Smart Copy and Smart Precedents/Dependents behavior.
Adds Paintbrush tool to facilitate the capture and reuse of cell formats.
Improves overall performance and fixes several issues/bugs.
Increases number of options in several number formatting cycles.
Includes ready-to-print list of Macabacus Macros shortcuts.
Adds Harvey Ball shapes.
Changes several shortcut keystrokes to improve consistency with other macro solutions.