Documenting Excel VBA code

[OldFuddy]

I need to document the code in an Excel workbook I have developed.

I need to show the code hierarchy, for example what code a button calls, what macros are called by what other macros.


Does anyone know of a way to produce this documentation ( other any me doing it manually ) ?

 

[bobhc]

Good day OldFuddy


I think this is what you may need


http://www.myengineeringworld.net/2012/11/list-all-your-vba-procedures.html

 

[NARAYANK991]

Hi ,


You may find this too useful :


http://blog.contextures.com/archives/2012/07/10/document-your-excel-vba-procedures/


http://www.mztools.com/index.aspx


Narayan

 

[OldFuddy]

Thanks both - this will get me started.