I want to completely replace a sheet in my current spreadsheet from an identically named sheet from a master spreadsheet (macro within a button).
The sheets of the target sheets contain named ranges. The sheets of the master also contain these same named ranges.

I'm using this code:

Please Login or Register  to view this content.
I want to copy the sheets and the named range definitions from the master into the target.
When VB does the copying the following message comes up for every named range:

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

I want the VB script to automaticially say "yes" to this question everytime.