I removed that line and now the colors aren't working. Does something else
need to be changed as well?

Also, I removed the code completely and then repasted it and it still didn't
work. I changed the password in your code to the one I had set for me file
and it still didn't fix it (I had already changed the password to match mine
in the one that worked to change the colors but forgot to mention it in my
earlier post).

Thanks!
--
JWeaver


"Gord Dibben" wrote:

Remove this line

OldCell.Borders.LineStyle = xlLineStyleNone


Gord

On Tue, 2 Sep 2008 06:59:15 -0700, JWeaver
wrote:

Thanks, Gord!

That worked to color the cell, however, it wiped out my cell border I had in
place. Can I modify the code you specified to put back the cell border? I
can't set up to print gridlines because it puts lines where I don't want them
on the Form.

Thanks!!