There is a great addin by Chip Person to do excatly what you are looking for...

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

--
HTH...

Jim Thomlinson


"Rhonda" wrote:

How do I automatically have a cell highlight when it is selected, regardless
to where the location is in the spreadsheet?