Restrict macro to one/native workbook

Hello.

I have a problem with code which runs periodically (every 30 seconds).

Basically, the code compares data from two Sheets (at the same Workbook) and then paste data (under certain conditions) from Sheet4 to Sheet1.

However, when I open some other Workbook (window on that "other" Workbook is active) and I start with my new project, the code from previous Workbook then paste results into that new Workbook also!?

So, this is what happened and what I actually want to do:

- I open Workbook 1 with the macro in it and it runs perfectly (great!)

- I open WB2 (Workbook1 is still open, macro still runs) and when WB2 is active then macro from WB1 start to paste data into WB2 (problem)

- I want macro from WB1 to keep working only in WB1 no matter the active workbook

Here is the code:

Please Login or Register  to view this content.