Microsoft KB Archive/930071

= Add-ins that contain code to automatically perform a move operation or a copy operation do not work correctly in Excel 2007 =

Article ID: 930071

Article Last Modified on 10/15/2007

-

APPLIES TO


 * Microsoft Office Excel 2007

-



SYMPTOMS
Consider the following scenario:
 * You install an add-in that uses code to automatically move or copy a worksheet from a Microsoft Office Excel 2007 workbook to another Excel 2007 workbook.
 * You open an Excel 2007 workbook that has macros disabled.
 * You run the add-in.
 * In the add-in dialog box, you select to move a worksheet to another Excel 2007 workbook that has macros enabled.

In this scenario, when you click Continue in the security dialog box, the Save As dialog box may not appear. Additionally, Excel may open a new workbook that contains the selected worksheet.

If you click No in the security dialog box, the Save As dialog box appears. Additionally, you are prompted to save the workbook. When you close the Save As dialog box, the original workbook is closed. Then, the add-in dialog box appears.



CAUSE
This problem occurs if you install an add-in that contains code to automatically perform a move operation or a copy operation in Excel 2007. In this case, the copy operation cannot be performed. Additionally, the code that the add-in contains is reset.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Additional query words: xl2007

Keywords: kbtshoot kbprb kbexpertiseinter KB930071

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.