Name warning when copying template

I create a worksheet from a template, the target sheet has named ranges on it to provide input to a summary row.
The summary row on the template has the names in the formulas even though they don't function on the template.
When the summary rows are copied and pasted to the target worksheet I get the warning:

"A formula or sheet you want to move or copy contains the name "...", which already exists on the destination worksheet."

I can hit "ok" at each prompt which is fine for me but I don't want the user to have to even think about it.

Is there a way I can cause this to be ignored or have "OK" be an automatic answer?
a better work around?

In case it helps, code:

Public Sub InsSumRows()
'Insert Summary Footer
    Dim mySpace As Range
    
    
    Worksheets("FA_Template").Range("faTempSumRows").SpecialCells(xlCellTypeVisible).Copy

    Range("a1").End(xlDown).Offset(2, 0).Select

    Set mySpace = Selection

    With Selection
        .PasteSpecial Paste:=xlPasteFormulas, Operation:= _
        xlNone, SkipBlanks:=False, Transpose:=False
        .PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    End With

End Sub

thanks
Robert

Perfect D!
Thanks
Robert

Originally Posted by DGagnon

Try putting this at the beginning of your code:

Application.DisplayAlerts = False

Set it back to True at the end.

like this

Public Sub InsSumRows()
'Insert Summary Footer
Application.DisplayAlerts = FALSE

    Dim mySpace As Range
    
    
    Worksheets("FA_Template").Range("faTempSumRows").SpecialCells(xlCellTypeVisible).Copy

    Range("a1").End(xlDown).Offset(2, 0).Select

    Set mySpace = Selection

    With Selection
        .PasteSpecial Paste:=xlPasteFormulas, Operation:= _
        xlNone, SkipBlanks:=False, Transpose:=False
        .PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    End With

Application.DisplayAlerts = TRUE
End Sub