Alan wrote:
I then copy both worksheets via "Edit, Move or Copy
Sheet" to a new workbook.

Do you copy them as a group? (click one tab and Shift+Click the other
before Edit / Move or Copy Sheet).
If you did, I doubt you would have this problem.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup