VBA-CodeAnalyzer this code can extract macro's information from Excel Workbook. In the "CodeAnalyzer" Ribbon, click "this Book" or "other Book" button. this uses VBAFormatter install script. screen shot