Name warning when copying template

[Hammer_757]

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:

Please Login or Register  to view this content.

thanks
Robert

[DGagnon]

Try putting this at the beginning of your code:

Please Login or Register  to view this content.

Set it back to True at the end.

like this

Please Login or Register  to view this content.

[Hammer_757]

Perfect D!
Thanks
Robert

Try putting this at the beginning of your code:

Please Login or Register  to view this content.

Set it back to True at the end.

like this

Please Login or Register  to view this content.

[DGagnon]

Anytime!

glad i could assist.