Hello,
this is an interesting concept.

How do you determine "Mapping"?

Do you want to trace each worksheet in each sheet?

maybe I will think of something. Send me one of the workbooks. Maybe I can
"capture" the Trace dependants in each worksheet then "write" the dependants
into a textbox. not sure if it will work though.. just a thought. Not sure if
VBA will allow me to contain the trace.

- -Mark



http://www.geocities.com/excelmarksway


"ixlr84fun" wrote:

I have some fairly complicated excel files with let say 100 worksheets
in them.

What I would like to do is be able to generate a "map" that would
show me graphically how all the worksheets in the file are linked to
each other.