Help and Support

XL97: Cannot Modify Microsoft Excel 5.0 or 7.0 Add-in

Article ID:160131
Last Review:October 10, 2006
Revision:1.2
This article was previously published under Q160131

SYMPTOMS

In 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:
Project is unviewable
You cannot edit the worksheets or modules in the project, and you cannot modify any of the project properties.

Back to the top

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.

Add-ins that you save in a format for use with earlier versions of Microsoft Excel are protected; you cannot access the worksheets in Microsoft Excel, and you cannot access the modules in the Visual Basic Editor. These protective measures are used to protect the add-in being changed. Microsoft Excel uses a random password to protect the project, which prevents the add-in from being unprotected.

This behavior is by design of Microsoft Excel.

Back to the top

RESOLUTION

To 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.

Back to the top

MORE INFORMATION

For additional information on creating Microsoft Excel 97 add-ins, please see the following article in the Microsoft Knowledge Base:
156942 (http://support.microsoft.com/kb/156942/EN-US/) XL97: How to Create an Add-in File in Microsoft Excel 97

Back to the top


APPLIES TO
Microsoft Excel 97 Standard Edition

Back to the top

Keywords: 
kberrmsg kbprb kbprogramming KB160131

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.