XL: Error Inserting a Module Sheet in a Workbook

• Microsoft Excel 97 for Windows
• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel for Windows, version 5.0

SYMPTOMS

In Microsoft Excel 7.0 or 5.0, when you attempt to insert a module sheet into a workbook, you may receive the following error message:

   Can't find project or library

NOTE: This problem may also occur when you attempt to record a macro, and then store the recorded macro in the active workbook.

CAUSE

This problem may occur if all of the following conditions are true:

• In Microsoft Excel 97, you create a workbook and save it in the "Microsoft Excel 5.0/95 Workbook" format.

  -and-

• The workbook has at least one module sheet in it.

  -and-

• In Microsoft Excel 5.0 or 7.0, you insert a module sheet in the workbook.

WORKAROUND

To work around this problem, do the following:

1. When the error message appears, click OK.

2. When the References dialog box appears, clear the check box next to:

         MISSING: Microsoft Office 8.0 Object Library
   

3. Click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

When you save a Microsoft Excel 97 workbook in an earlier version file format, Microsoft Excel saves general modules as module sheets in the workbook. However, Microsoft Excel does not save the following items:

• Code that is associated with an object module
• Forms
• Class modules