Not run Worksheet_Change if values change by macro in a module

[cgkmal]

Hi everyone,

I have "MyMacro" in a standard module that changes values in range B7:H100 of "Sheet1" and
in "Sheet1" module I have a Sub Worksheet_Change event, that runs when values change in the same range B7:H100.

What I want is that "Sub Worksheet_Change" event only runs when I enter manually data in B7:H100 and do nothing when
"MyMacro" change the values in cells in B7:H100.

How can I do this?

Many thanks for any suggestion.

Regards

[tigeravatar]

cgkmal,

Please Login or Register  to view this content.

Hope that helps,
~tigeravatar

[cgkmal]

Hi tigeravatar,

Yeahhhh! Itīs logical But the problem is I never thought in that jajaja.

It works exactly as I wanted.

Many thanks for your help.

Best regards