You can't change the color of specific lines of code in the editor. You
could mark with comments the code that needs to be changed and search for
those comments when you need to change the code. Better yet, of course,
would be to properly write the code such that it doesn't need to be changed
from one year to the next.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"JT" wrote in message
...
Is there a way to change the color of a couple of lines of code. Each
year I
have to search through a lot of code to modify specific lines. I was
wondering if there is a way to change s line or two of code to a different
color (say red), so next year I can scroll through the code and look for
the
red lines?

I've looked at the options in the VB Editor but couldn't find a way to
change a line and keep it that color when I re-open the Editor.

Thanks for the help.....Mike
--
JT