Print code in color

slickity · Oct 20th 2005

This is not a question directly on VBA I guess, but I'd like to print a bunch of code in color. This is because I have a workbook with probably 50 or so Subs in 12 modules, and I've made some many changes over the past month or so that I've lost all sense of organization to the project, so I'd like to get it all in front of me.

Anyway, when I print to a color printer from VBA, I still get black and white.
Is there any way to get color?
Thanks.

slickity · Oct 20th 2005

Re: Print code in color

I deffinitely could do that, but I just printed the project, and it topped 20 pages of code, which I don't want to have to go through and manually recolor.

**norie** · Oct 20th 2005

Re: Print code in color

slickity

Who said you would have to manually colour it?

You could use VBA (or maybe even conditional formatting) to format it as required.

Check the link I added when I edited my post.

Seti · Oct 20th 2005

Re: Print code in color

If you are not averse to spending some cash, this product is pretty cool:

http://www.starprint2000.com/vbprint_features.html

I use it and it has some very nice features.

Print code in color

Participate now!

Share