The Code Documentor
The Excel Code Documentor automatically documents the vital statistics of your VBA project. These statistics include:
- A complete procedure listing for all modules in an outlined worksheet.
- A summary of the number and type of VBComponents used in the project.
- The number of procedures in the project, both total and per VBComponent.
- The number of DLL declarations in the project, both total and per VBComponent.
- Total lines of code in the project and per VBComponent.
- Module file size for each code module.
Installation and Operation
Before installing the Code Documentor you must set your security to trust access to Visual Basic projects.
- Excel 2010 and Later - Choose File > Options > Trust Center > Trust Center Settings > Macro Settings. Check the checkbox labeled Trust Access to Visual Basic Project and click OK twice to finish.
- Excel 2007 - Choose Office Button > Excel Options > Trust Center > Trust Center Settings > Macro Settings. Check the checkbox labeled Trust Access to Visual Basic Project and click OK twice to finish.
- Excel 2003 and Earlier - Choose Tools > Macro > Security from the Excel menu and click the Trusted Sources tab. At the bottom of this tab you'll see a checkbox labeled Trust Access to Visual Basic Project. Check this option and click OK.
Download
Download the Code Documentor (Version 5.08)