Thanks for your answer. That also explains why I haven't been able to find a solution for this.

If you have any ideas on how to apply a similar method to other open files (which are copies with other data) that affect the one running the macros, I would happy to hear your suggestion.