Find hidden cells and risky macros

Find hidden cells and risky macros

In version 12 of Rainbow we’ve added several new risk analysis options to the Risk Map function. We’ve done this by moving some “mapping” options from the last Risk Map tab across to the Logic Analysis function (see previous post). And we’ve also added an option to analyse any VB macro code in the workbook.

You can see from the screenshot above that the last Risk Map tab is now about “hidden” cells. These new options will reveal any attempts to hide sensitive cell contents by (for example) hiding a row or column, or applying a custom format such as “;;;”. And the “hidden operators” option will show up any double negatives (easily missed), plus the new implicit intersection operator “@”.

There are also new options on the other Risk Map tabs. These include an option to report any cells with “=SUM()” where the summed range includes subtotals, a very common cause of double-counting errors. You can also report where Excel’s own error checks have found issues, and the report on array formulas now includes the recently-introduced “dynamic arrays”.

The screenshot above also shows another new version 12 feature; a report on macro code issues. This checks for what are probably the two most common macro risk indicators:

  • Macros which run automatically when the workbook is opened; this is a technique regularly used in some types of malware.
  • Macros which have been created using Excel’s built-in macro recorder; this often results in macros which are liable to break or behave unpredictably.

So the Risk Map function in Rainbow version 12 is considerably more powerful than the previous version, and can make it much easier for you to find and correct potential problems in your spreadsheets!

Sorry, comments are closed for this post.

Back to topAdministration