The information in this article applies to:
SYMPTOMSIn the Visual Basic Editor, when you attempt to access a project for an add-in saved in the Microsoft Excel 5.0 or 7.0 file format, you receive the following error message: You cannot edit the worksheets or modules in the project, and you cannot modify any of the project properties. CAUSE
When you run a Microsoft Excel 5.0 or 7.0 add-in in Microsoft Excel 97, the
behavior of the add-in remains unchanged. However, the method that you use
to edit and protect an add-in in Microsoft Excel 97 is different from the
method you use in Microsoft Excel 5.0 or 7.0.
RESOLUTIONTo edit and modify an add-in that is created in Microsoft Excel 5.0 or 7.0, open the source workbook used to create the add-in, and make modifications to the source. After you modify the source workbook, create a new add-in from the source workbook. MORE INFORMATIONFor additional information on creating Microsoft Excel 97 add-ins, please see the following article in the Microsoft Knowledge Base: Q156942 XL97: How to Create an Add-in File in Microsoft Excel 97 Additional query words: XL5 XL95 XL97 8.0 8.00 project locked addin not viewable invisible hidden
Keywords : kberrmsg kbprg kbdta xladdins KbVBA |
Last Reviewed: November 9, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |