Sub / Function recorder

[theta]

Hi all...looking for some help on a project. I have inherited an existing excel solution (20,000 lines of code and 1,300 procedures).

I want to build a master tree to record the interaction of these modules. The easiest way to start would be to record each sub (and its parent module) called, along with each function (and parent module) called. There is an on open event that triggers this process.

I tried to do it manually but it quickly spirals into a few hours work - any way to print to a text file / workbook everytime a sub/function is called?

Thanks

[theta]

Sorry should have said. Would be hoping for this output to be visual so that I can trace the calling procedures etc.

Like when using MZ Tools procedure caller - but for every procedure and function called.