Highlight Row Without Saving

[caffeineaddict]

Hi All.

This maybe really simple but I have the below VB Code snippet to highlight the active row on a sheet.
The problem i have is that when i save the file the colour remains on the sheet when I reopen it and alters the layout style, is there anyway to prevent it from saving the colour over my layout?

Thanks

Please Login or Register  to view this content.

[protonLeah]

Try this one instead:

Please Login or Register  to view this content.