OFF95: Cannot Exit Binder That Contains Module Sheets Only

ID: Q135663

7.00 WINDOWS kbtool kberrmsg

The information in this article applies to:

- Microsoft Office for Windows 95, version 7.0

SYMPTOMS

If you create a Binder document that only contains Microsoft Excel module sheets, you will be forced to click View Outside on the Selection menu to view the module sheet. This will take you to the Microsoft Excel program. When you try and exit Microsoft Excel through normal means, you will receive the following error message:

   Cannot close with a module active. Please switch to another
   sheet in the workbook.

CAUSE

Module sheets are not OLE objects, so they cannot be displayed within a Binder (which is an OLE container). When you try to exit Microsoft Excel from View Outside, it is necessary to revert back to the Binder. Because it is not possible to display the module sheet in the Binder itself, the above error message is generated.

This behavior is by design.

RESOLUTION

To resolve this issue, add a worksheet or a chart sheet to the workbook before you exit it. The worksheet or chart sheet must be the active sheet in order to return to the Binder.

MORE INFORMATION

Although the Binder initially displays a view of the workbook as an icon when it is first added, there is no way to return to that view when you switch to the binder from view outside.

KBCategory: kbtool kberrmsg KBSubcategory:

Additional reference words: 7.00 XL7

Keywords            : kberrmsg kbtool
Version             : 7.00
Platform            : WINDOWS

Last Reviewed: March 10, 1997