John, you can just drag it to the workbook name and it will put the module
in for you

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"John" wrote in message
...
Ok... now I got it. I had to create a module in the new workbook. Then I
could drag the macros to it. Without any macros and hence no module in
the new workbook there was nothing to drag to.

Thanks

John

Paul B wrote:
John, when you have both open and in VBA, click on the module you want
to
copy, left click and hold the mouse button down and drag it to the other
workbook, as far as I know you have to export and import one module at a
time using file, export, import. Can you put all the macros in on module
and
then just export it?