How to Stop Macro From Requiring File Open Prompt When Changing External WB Reference?

The following macro works okay with the exception of prompting me to open the file location over 500 times for each of the 500 formulas that I copy over from Column B to Column C. Also, after pasting the formulas the macro uses Find/Replace to update the file path from the previous month to the current month. Finally, the formulas reference a closed external workbook:

Please Login or Register  to view this content.

I thought that adding "ScreenUpdating = False" would suppress these open file prompts, but it doesn't seem to be having an effect. Is there a solution to suppress these prompts?

Are you calling this macro from another? Did you try application.displayalerts on the other macro? Otherwise I don't see where it is opening anything?

Actually, that worked! When I use

Please Login or Register  to view this content.

the Open File prompts are suppressed just like I wanted. Thank you.