Highlight Yellow Active Row, PROBLEM: row selected before closing stays yellow

Greetings,
I found this code on another thread posted last summer

The code does *exactly* what I wanted it to do: highlight the active row yellow without overwriting any conditional formatting.

The only problem is: when you save/close the workbook, and re-open, the last row that was selected before closing remains highlighted and it doesn't go away unless you manually select the row and change the fill. This issue was raised by the original poster but no-one ever replied. I hope I'm not breaking any forum rules by reposting.

Below is the code and attached is a workbook with an example of how the row stays yellow.

Active Row Highlight Problem Example.xls

Thank you kindly in advance for your help!!

Please Login or Register  to view this content.

Hi,

try:

Please Login or Register  to view this content.

Thank you for the reply! Yes, this has solved the problem of the row staying yellow. The only issue now is ... when I applied it to my actual workbook, the marco is running a bit slow. Every time I move over or down a cell, my mouse changes to the little hour-glass for a second. Any other possible solutions out there?

Yesterday I replied to the wrong thread, sorry.
Take a look at this (if it helps): http://www.excelforum.com/showthread...=1#post3117881

Rollis13 - thank you! That works perfectly.

Glad being of some help .