Try

Sub Macro()
Application.DisplayAlerts = False

'your code here

Application.DisplayAlerts = True
End Sub

If this post helps click Yes
---------------
Jacob Skaria


"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