Summarizer does not detect VBA code in the active workbook

Problem
The active workbook contains VBA code but the "Procedures" worksheet does not list your VBA subroutines. There are two reasons for this problem:

1. Your VBA code has been protected
2. You are running Excel XP or later and your security settings disallow access to VBA code

Solution
With regard to i, unprotect your VBA code and re-run Summarizer.

With regard to ii, change your security settings so that Summarizer can access your VBA code. Follow these steps to change your security settings:

1. Open the Tools menu from Excel’s main menu
2. Click on Macro and then on Security …
3. When the Security dialog box opens, click on the Trusted Sources tab
4. Check the "Trust access to Visual Basic project" checkbox
5. Click on OK