Microsoft KB Archive/111086

Microsoft Knowledge Base

XL: Cannot Display Visual Basic Modules in Print Preview

Last reviewed: March 27, 1997
Article ID: Q111086

5.00 5.00c 7.00 7.00a | 5.00 5.00a

WINDOWS                 MACINTOSH

kbprint

The information in this article applies to:

• Microsoft Excel for Windows, versions 5.0, 5.0a
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a

SUMMARY

In Microsoft Excel it is not possible to view a Visual Basic module in print preview.

Also, if more than one sheet is active (you are in Group Edit mode), and if one of the sheets is a Visual Basic module, you will be unable to view any of the other sheets in print preview until you remove all Visual Basic modules from the group.

The only way to tell what a Visual Basic module will look like when it's printed is to print it. When you are in a Visual Basic module, the Print Preview command on the File menu will be unavailable (dimmed).

WORKAROUND

Highlight the code that you want to print or preview (either a partial section or the entire module). Select Copy from the Edit menu, open a new worksheet and paste the code into it. Be sure that you are not in Group Edit mode (more than one sheet active). The code pastes in properly and allows conventional printing methods and ability to preview.

KBCategory: kbprint KBSubcategory: Additional reference words: 5.00 7.00 Keywords : kbprint Version : 5.00 5.00c 7.00 7.00a | 5.00 5.0 Platform : MACINTOSH WINDOWS THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Last reviewed: March 27, 1997 ©1997 Microsoft Corporation. All rights reserved. Legal Notices.