Hi Dave,
That would be wonderful! I was just thinking about going to go write a
macro myself. I would greatly appreciate your allowing me to use yours
instead.
Many thanks,
Sarah Jane
"DGolds" wrote:
> 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...b;en-us;213191
> > XL2000: Modules Cannot Be Printed in Color
> >
> > http://support.microsoft.com/default...b;en-us;173083
> > Modules Cannot Be Printed in Color
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Sarah Jane" <SarahJane@discussions.microsoft.com> wrote in message
> > news:AB314BF5-C38B-436E-B7A5-DE553417A246@microsoft.com...
> > > 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@discussions.microsoft.com> wrote in message
> > > > news:54A66868-055D-48CE-9128-934690CEA685@microsoft.com...
> > > > > 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
> > > >
> > > >
> > > >
> >
> >
> >
Bookmarks