XL: Modules Cannot Be Printed in Color

ID: Q173083

The information in this article applies to:

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.

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

Additional query words: XL97 XL98 XL7 XL5 sheet OFF97 vbe

Keywords          : kbprg kbprint kbui kbdta OffVBA PgmOthr KbVBA 
Version           : MACINTOSH:5.0,5.0a,98; WINDOWS:5.0,5.0c,7.0,7.0a,97
Platform          : MACINTOSH WINDOWS
Issue type        : kbprb

Last Reviewed: January 3, 1999