cancel Events using macro?

[chibouki]

Hello,
I have a Sub that is executed when a Change event occurs in column D.
I have also a macro that add a line and copy the content of another line into it.
Everytime the macro runs, the Sub when Change runs also.
Is there a way to run a macro without having the Sub when Change to run?
Thx
David

[chergh]

In the macro where you add a line and copy the contents add this line before you add the line:

Please Login or Register  to view this content.

After you have added the line and have copied the values add the line

Please Login or Register  to view this content.