I did not test but try
Application.DisplayAlerts=false
and then reset after the copy
Application.DisplayAlerts=true

I know this works to suppress the message when deleting sheets

--
If this helps, please remember to click yes.


"Larry Fitch" wrote:

I have an excel sheet that get imported into another workbook by way of a
macro.. This sheet contains two drop down lists.

When I run the macro I get an info box that pops up telling me:

"A formula or sheet you want to move or copy contains the 'YES_NO' which
already exists on the destination worksheet. Do you want to use this version
of the name?"

Can I add any code to the macro to always say yes to this and not see the
dialogue box ??


--
Thanks

Larry