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.