You could create an xla (add in) which you can package off or you can
add code by code, take a look at Chip Pearsons site, there is coe ther
which is very well laid out and explained.

JLR-Mart;261485 Wrote:
I have written several modules and forms that combine to provide a
complete
solution to a problem within our business, but I need to have these
modules
and forms available within hundreds of files which I then mail out to
users
within the company.

So far I have been dragging and dropping the relevant modules into the
excel
documents manually.

Is there a simple way (add ins maybe) that will allow me to achieve the
same
result in and automated fashion???


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=72960