Re: Print VBA code in Editor format colors

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Sarah,
I developed a macro in Word that will color all of your comments green and
put a line under each sub or function (in code that you have pasted into Word
from the vbe of any MS office program). I was originally going to go all out
and have it color the keywords blue as well, but I ran out of motivation-it
seemed to me that having the comments green and separating the procedures
acheived my goal of making it more readable. Anyway, let me know if you're
interested and I'll post the code.
-Dave

"Tom Ogilvy" wrote:

> Just some added:
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;213191
> XL2000: Modules Cannot Be Printed in Color
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;173083
> Modules Cannot Be Printed in Color
>
> --
> Regards,
> Tom Ogilvy
>
> "Sarah Jane" <SarahJane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:AB314BF5-C38B-436E-B7A5-DE553417A246@xxxxxxxxxxxxxxxx
> > Thanks. I think I'll go post a Suggestion for Microsoft. :^)
> >
> > Sarah Jane
> >
> > "Tom Ogilvy" wrote:
> >
> > > The vbe does not print in color.
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Sarah Jane" <SarahJane@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > > news:54A66868-055D-48CE-9128-934690CEA685@xxxxxxxxxxxxxxxx
> > > > I originally posted this question on 8/8/2005 in
> > > > microsoft.public.office.developer.officedev.other, but since I still
> have
> > > not
> > > > gotten any response, I decided to try again by posting it in this
> > > Discussion
> > > > Group.
> > > >
> > > > In the Visual Basic Editor under Tools -> Options -> Editor format, I
> can
> > > > specify the code colors for Normal Text, Comment Text, Keyword Text,
> etc.
> > > > This is a wonderful feature when trying to edit a macro. However,
> when I
> > > > print the code so that I can review it and pencil in edits that I want
> to
> > > > make when I return to my computer, everything is black even though I
> sent
> > > it
> > > > to a color printer. IS THERE A WAY TO PRINT THE CODE IN THE SPECIFIED
> > > > COLORS? I tried selecting all, copying, and pasting into a Word
> document
> > > in
> > > > hopes that it would retain the colors, but it doesn't. Any other
> ideas?
> > > >
> > > > Sarah Jane
> > >
> > >
> > >
>
>
>
.

Relevant Pages

  • Re: Selection Data from a Range
    ... changed them in the VBE. ... Regards, ... Tom Ogilvy ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: List of all Macros in Personal.xls
    ... See Chip Pearson's site for sample code on working with the vbe: ... Regards, ... Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: VB Code Source
    ... use the object browser in the VBE. ... Regards, ... Tom Ogilvy ...
    (microsoft.public.excel.programming)
  • Re: Store hidden information in a spreadsheet
    ... Or you can go in the VBE and do it manually. ... Regards, ... Tom Ogilvy ... > Or put the info on a separate sheet and hide that sheet. ...
    (microsoft.public.excel.programming)
  • Re: New Orleans
    ... adressesed to Sarah Wroot personally: ... For the very few that need to look, try googling for "Wroot Vance" ...216 ... Regards ... > Jill Bowis ...
    (uk.business.agriculture)