keeping track of flow for modules/forms/sheetcodes

[rob nobel]

In the process of creating a workbook, I am accumulating many forms,
Modules, sheets, etc., some of which are linked backward and forwards.
Is there a process whereby I can either print the code out, or view the
procedures, in a way that will give some order to it for checking.
Failing that.... an easy way to print all code including those within
userforms to a file that I can view and edit and print?
I realise there is a print option under file in VBA that will print to file,
but not in a format I can read.
Rob

 

[jaf]

Hi Ron,
Chip Pearson has code to export modules from a project.
You can then open them in any text editor or use a tool like Pretty Code to
print them in color. www.prettycode.com

Look for "Exporting all modules". http://www.cpearson.com/excel/vbe.htm



--
John
johnf 202 at hotmail dot com


| In the process of creating a workbook, I am accumulating many forms,
| Modules, sheets, etc., some of which are linked backward and forwards.
| Is there a process whereby I can either print the code out, or view the
| procedures, in a way that will give some order to it for checking.
| Failing that.... an easy way to print all code including those within
| userforms to a file that I can view and edit and print?
| I realise there is a print option under file in VBA that will print to
file,
| but not in a format I can read.
| Rob
|
|

 

[rob nobel]

Thanks jaf, I should check those pages more often as there's a lot of
useful stuff there!
Rob