Changing active cell to a color

[Bob Reynolds]

I have a need to have the active cell in my worksheet to be a highlighted
color for easy recognition. Is there a way to program whatever cell is
active to change to highlighted color and have the highlight move from cell
to cell.
thanks in advance
Bob Reynolds

 

[Bob Reynolds]

Hello again, thanks to all that responded I knew I could count on someone
helping but especially nice to get 3.

Don Guillett works great for an unprotected worksheet. !!!I have one other
issue with this problem. The worksheet is protected so that when pressing
the tab button, only certain cells that are "unprotected" are accessible.
My problem is how do I leave the protection on to enable the specific cells
to be tabbed to and maintain the color of the selected cell?
Can I use a macro to only allow the use of certain cells within the workbook
and have the specific cells change color and protect and/or unprotect as
needed....
Hope I'm clear
Thanks
Bob Reynolds

 

[Don Guillett]

Depending on version you may allow users to format cells. 3rd option on
xl2002. xl97 does not have this option.

 

[Bob Reynolds]

Soooo Simple. Thanks so much Don, that completely solved my problem. I
appreciate your help
Bob

 

[Don Guillett]

glad to help