XL: Modules Cannot Be Printed in Color

• Microsoft Excel for Windows, versions 5.0, 5.0c
• Microsoft Excel for the Macintosh, versions 5.0, 5.0a
• Microsoft Excel for Windows NT, version 5.0
• Microsoft Excel for Windows 95, versions 7.0, 7.0a
• Microsoft Excel 97 for Windows
• Microsoft Excel 98 Macintosh Edition

SYMPTOMS

In the products listed at the beginning of this article, certain lines of Microsoft Visual Basic for Applications code in a module appear in color while you are editing them. However, when you print the module, these lines of code are printed in black and white, even if you have a color printer.

CAUSE

Printing of color in modules is not a supported feature.

STATUS

This behavior is by design.

MORE INFORMATION

The following table lists the default settings for items in a module that may or may not be displayed in color while editing the code of the module:

   Item                Default color
   ---------------------------------

   Normal text         Black
   Syntax error text   Red
   Comment text        Green
   Keyword text        Blue

REFERENCES

For more information about printing Visual Basic for Applications code, click the Office Assistant in the Visual Basic Editor, type "printing a project," click Search, and then click to view "Print Command (File Menu)."

NOTE: If the Assistant is hidden, click the Office Assistant button on the Standard toolbar. If Microsoft Help is not installed on your computer, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q120802
   TITLE     : Office: How to Add/Remove a Single Office