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

The vbe does not print in color.

--
Regards,
Tom Ogilvy

"Sarah Jane" wrote in message
...
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

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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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

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" wrote in message
...
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" wrote in message
...
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