Right click sheet > Select view code > Paste in code

So if your in sheet 1 it will hightlight the activecell row only for that sheet

http://www.contextures.com/xlvba01.html#Worksheet

VBA Noob