I have a working Excel macro that combines data from several other files that all have the same layout. My annoyance is that it prompts me for each file being opened saying that it contains macros, etc and do I want to continue.

Is there a way to bypass this so the entire process is more streamlined?