How to turn off notifications

Good morning everyone,

Can someone let me know how to turn off notifications when the macro is running?

Background:

This macro copies data from several files and paste it in another. Each time the macro tries to close the source file I have to "click" on the notification window to not update data and again not to save. I am pulling from 6 different files so the pop up notifications are a pain in the rear.

I would think this would be a simple fix, but I am having a hard time.

Thank you in advance for your time and help.