Please help if you are able.

I have found that if I manually copy a sheet by right
click on the sheet tab and select "move or copy" then send
the sheet to another workbook it takes the VBA code stored
in the sheet module with it.

But, if I run the VBA to do this, the VBA code stored in
the sheet module is not included in the copy. I need to be
able to do this from code. Can someone supply me with the
VBA to do this (Excel XP/Win 2000)?

Your example code will be most appreciated. Thanks in
advance for your assistance.