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.

Originally Posted by TMS

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

Please Login or Register  to view this content.

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

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.