Hi Rick,

Did the code which I suggested not work for you?


---
Regards,
Norman


"MikeZz" wrote in message
...
Actually I know how to do it manually. I'm looking for a way to do it in
VBA
because I'm using one wb to create another and I want to send the new wb
some
code and forms.

Thanks anyway.

"Rick Rothstein (MVP - VB)" wrote:

I'm using VBA to set up a new workbook.
I want the new workbook to have stand alone macros and user forms.

I can create the user forms and macros within the workbook that I'm
copying
from.

I just want to duplicate those into the new workbook.

I returning to Excel after a long, long absence from it, so I am quite
rusty
on many things; but, I would think you could just Export the stuff you
want
from your current workbook and then Import it into the new workbook.

Rick