I want to vba-copy a worksheet with names

[peter grandjean]

Hi.
I want to make a copy a worksheet including names etc.

I use the statement
Worksheets("new sheet").Copy Before:=Sheets(2)

When executing this I am asked if I want to use the names that alleready exist. The answer is allways yes. Can I build those "yes" into the vba ?

Regards

Peter

 

[venkat1926]

at the beginning add a statement

application.displayalerts=fa;se

and at the end before end sub add staement

application.displayalerts=true

see whether it helps

 

[peter grandjean]

Thank you. It was what I was looking for.

Regards

Peter