Hi Chip,

I was just wondering, are these steps really necessary???
Wouldn't it just be easier to copy the source code from
a source module and then paste into whichever module
I choose?? Just curious...

thankx


"Chip Pearson" wrote in message
...

The following code will copy the module named in ModuleName from
SourceWB to DestWB. You'll need a reference to the VBA Extensibility
library. In VBA, go to the Tools menu, choose References, and scroll
down to "Microsoft Visual Basic For Applications Extensiblity Library
5.3" and check that item. Change the lines marked with <<< to the
value appropriate for your circumstances.