Tom,

Many thanks.

The link you provided has certainly pointed me in the right direction but
l'm beginning to think it might be a bit beyond my capabilites. However l
shall "give it a go"

Regards

"Tom Ogilvy" wrote in message
...
The code at

http://www.cpearson.com/excel/vbe.htm

doesn't do specifically what you ask, but certainly provides sample code
to
roll your own.

--
Regards,
Tom Ogilvy


"Michael Beckinsale" wrote in message
...
Hi All,

I have found some utilities on the web which produce a report of the
contents of Excel workbooks and VBA modules etc. However none of them
actually list the VBA code contained in the ThisWorkbook & Sheet Objects
or
code Modules.

Does anybody know if a utility exists and where to find it ?

Alternatively can anybody provide code to search ThisWorkbook & Sheet
Objects and code modules. Then if code exists, copy and paste the code
into
a new worksheet ?

I know l can print from the modules directly but it would be nice to be
able
to produce a "Technical Specification" for each of my products.

All comments greatfully received

Regards

Michael Beckinsale