Microsoft Excel security, protect, encrypt, restrict access to spreadsheets, VBA code

Microsoft Excel security, protect, encrypt, restrict access to spreadsheets, VBA code

Spreadsheet professional


Spreadsheet Professional is the world's most comprehensive Excel building, testing, documenting and usage tool. Spreadsheet Professional will:

  • automatically test for the most common excel errors
  • generate a full list of Excel Spreadsheet Documentation
  • provide tools to build more accurate Excel spreadsheets quickly
  • provide tools to assist with using spreadsheets
  • enable you to compare two spreadsheets to see what has changed.


Some of the tools include:

  • Map Report - give a structural representation of your excel model so you can identify any inconsistencies'
  • Error report - tests every cell for 'risky' procedures e.g. unused inputs, reference to blank cells, hardcoded numbers in a formula and many more
  • Comparison Report - compare 2 spreadsheets to identify changes made in inputs, formula or results
  • Formula Tracer - Creates a bubble diagram showing the source of a cells formula with references, labels and the numbers used. You can drill down all the way to the cells containing the inputs.


You can watch a video clip of some of the tools here or else visit the website AuditExcel to find out more.