View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leith Ross[_720_] Leith Ross[_720_] is offline
external usenet poster
 
Posts: 1
Default Printing macro comments in color


Hello Meg99,

The VB Editor adds the color to comment when displayed. The color
component is not saved with the text. This why when you copy the code to
clipboard, it remains as black type. The only two ways I can see to
print the comments is either save the code block as picture or write a
macro in Word to color the comment lines once they are copied over.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48245