Highlight Rows on ONLY ACTIVE WORKBOOK

In order to make it easier to follow the important data when multiple workbooks are used, I employ the typical CF and Target.Calculate in VBA. Unfortunately, everytime I jump from one workbook to another, all of the open workbooks jump to their corresponding line and get highlighted. This defeats the purpose of using it. Does anyone have a workaround so that only the active workbook has the desired highlighted row, and not all of the workbooks moving to the same corresponding row?

Thanks in advance.

Thanks for the reply, but it didn't work. Still highlight ghosting on all open workbooks that have the CF to highlight the active rows.

Originally Posted by TMS

Or, untested, but maybe insert, as the first line:

If ThisWorkbook.Name <> ActiveWorkbook.Name Then Exit Sub

Thanks, but it didn't stop the ghosting of the highlighting of the other open workbooks.