hey John,
Thanks for your reply...
When I put it under This Workbook, it completely stops working.. and I don't see how the Workbook_Close would help..

Is there anything I can edit or add to the code to ensure that when I reopen the workbook, it doesn't 'save' or 'remember' the last row highlighted and make it permanent??

Thanks in advance! really appreciate it!!