Move sheet to ANOTHER workbook, but Macro terminates itself!

First of all, thanks for you help!!

I tried the following but it still terminates itself...

Please Login or Register  to view this content.

Where is this code located and is there any event code in either workbook that might be in conflict? Also, do you have any UDFs in either workbook that you use in conditional formatting?
Can you post a sample of the two workbooks (no data necessary in either) that demonstrates the problem?

1. Only Workbook_Open and Workbook_BeforeClose exists, no other event codes (Codes for both wb A & B are identical)
2. There's no conditional formatting at all.....

I've attached a simple version of my workbooks. My codes with problem is in the Summary_Move Module.....
Please place WorkbookB.xls into C:\Temp (or need to modify code)
Please start by running the "Move Sheet" on WorkbookA.xls and you will see it stops after copying Report 1_GP to workbookB

Many Thanks!

I wonder if there is anything to do with the workbooks' codes being identical...
(so they have same module, same sub and same functions)
But the problem is I cannot delete any of the codes!
Any suggestion??

It is working for me. Copies all reports to workbookB.

JapanDave , do you mean you used my samples and it works fine??
I've tried on different computers but none work!
tried different versions of excel too (2003,2007,2010)
How did you make it work?? Did you change any codes??

JapanDave,
Yes! The WorkbookB you attached is exactly what it meant to be!
But it doesn't it work on my laptop! I have only Report1 but no Report2/ReportALL
It doesn't work on my colleague's laptop as well. We saw the coded jump from workbookA to workbookB, which it shouldn't do so, and stopped.
I ended up making a batch file to do the copy task.

Anyway, Thanks for your help!
And thank you to OnErrorGoto0 too
As both of you can get it work, I suspect the laptop model might be the cause.