View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
DaveL DaveL is offline
external usenet poster
 
Posts: 22
Default Printing macro comments in color

I used the free evalutation copy and it ws excellent, but not much use to me
because no extraneous programs are allowed on our system at work. I use a
non-color printer at home and, though this software provides some help, I was
looking for somethng more.

Someone named "DGolds" provided a good start with coloring comments green
and provided the code in another request for this capability. I took that
code and ran with it and was able to improve on coloring comments green and
then added coloring of key words, selected functions and "Call" Sub
procedures. I also added bolding, italics and underlining to get visual help
from black and white printers. It doesn't execute flawlessly as I'm still
working to remove some unintended coloring. The code is almost 300 lines
long and I don't know if it will load here but I'm more than happy to share
it. Maybe someone can improve on it.

"Gord Dibben" wrote:

Pretty-Print:

http://www.submain.com/?nav=products.pcp

has a free evaluation copy.


Gord Dibben MS Excel MVP




On Thu, 8 Jan 2009 12:16:47 -0800 (PST), meg99
wrote:

using 2003. In the editor I see the macro comments are colored
green. Is it possible to have it print that way as well?

meg99