Hi Jeff.

See Chip Pearson at:

Programming The VBA Editor
http://www.cpearson.com/excel/vbe.aspx



---
Regards.
Norman


"Jeff C" wrote in message
...
I have a function that creates new custom workbooks for each client and
distributes them across a network.

How can I get a macro automatically placed in the OnOpen event of each new
workbook when it is generated?

The workbooks are generated from the transferspreadsheet function in
Access
using Win XP Pro and Office 2003.

Thanks in advance

--
Jeff C
Live Well .. Be Happy In All You Do