conflict names when copy a sheet

[Melnik]

Hi everyone

I need some help in this:

In a excel workbook when I copy a worksheet (to duplicate with other name) there is always a name conflict and so I have to say yes (maintain the name) or say no (and excel ask for other names) many times (sometimes more than 50 times pressing the enter button. Its possible to disable this feature?

My best regards and Thanks in advance.

Melnik Kuhn

 

[VoG]

Possibly

Application.DisplayAlerts = False
'
'your code
'
Application.DisplayAlerts = True

 

[Melnik]

It works!

Thank you for your help!

Melnik Kuhn