When you use the code sheet.copy normally a new workbook is created with a copy of that particular sheet.
However in Excel 2007 (SP1) if the original workbook contains a macro when you run the code the first time you (might) get the following error:

I could only reproduce this error when the original workbook where [...]

Posted on June 3rd, 2008 by Bastien
Filed under: Excel 2007 info, General | Comments Off