It might be worthy to note that an often undesirable side effect of this is
that you will lose the ability to undo edits as many macros cause the undo
history to zero out.

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
for this you would need an event procedure. But maybe the following is
what you're looking for:

http://www.cpearson.com/excel/excelM...ightActiveCell
http://www.cpearson.com/excel/RowLiner.htm



--
Regards
Frank Kabel
Frankfurt, Germany


alldreams wrote:
this work. However, the color change remains after I
changed to a different cell. I want to dynamically
change the color of the activecell only

thanks!

-----Original Message-----
Hi
make this
Hi
activecell.interior.colorindex = 3


--
Regards
Frank Kabel
Frankfurt, Germany


Frank Kabel wrote:
Hi
activecell.colorindex = 3


alldreams wrote:
what is the best way to change the color of the
activecell?

Thanks for your help.
.