Disable Range Name Conflict Message

[MikeWard100]

Problem:
I have a macro that deletes yesterday's worksheets and copy's in today's version. I'm adding about 90 worksheets. Upon each worksheet addition, I get a message reading...

"A formula or sheet you want to move or copy contains the name "abcdef" which already exists in the destination worksheet. Do you want to used this version of the name?" I have to select "Yes" or "No".

For this macro, the answer is always "Yes". To execute the macro, I hold down the "Y" key for about 6 minutes while the macro completes.

Questions:
Is there a way I can either disable the dialog box, or program the macro to answer "Yes" for all worksheets?

 

[shg]

Application.EnableAlerts = False

 

[MikeWard100]

Amazing! Thank you!

 

[Aviles]

Hi guys, I have the same problem as above.

I have tried the "Application.EnableAlerts = False" code, but I still get the same message.

Can you tell me where I need to place this code?

Is it a combination of "False" and "True" similar to the "Application.ScreenUpdating = True/False" scenario?

 

[RoryA]

It's actually:

Application.DisplayAlerts = False

 

[Aviles]

Thank you!