Hello all,
I am working on file, that has two major elements. First macro is copying data from another file and pasting it to the sheet. Second is Worksheet_Change for some cells. If seperately, both work perfectly.
However, if I have Worksheet_Change active, running the first macro brings me a plenty of errors (because data are pasted to "controlled" cell).
What I wish to get is following:
Running first macro deactivates "Worksheet_Change" and activates it again after all procedures.
Any idea how to do that?
Thanks in advance.
Bookmarks