I create, copy, and use a lot of macro routines, mainly in Excel. Often I want to pass these on to others, so I try to comment all the macros, the copy them to Word documents with explantory text before and after the macro. When I do this, I'd like to be able to have all of my comment lines within the macros come out in green. Since every comment line begins with an apostrophe, it seems like it would be simple to have a Word macro that colors all lines beginning with an apostrophe green, but I don't know how to do it. I'd appreciate some help.
Thanks,
John
Bookmarks