Automatically answer Named Conflict Dialog with No and set Named range to variable

Hello,

I am having trouble handling the named range conflict box within a worksheet I am producing. Essentially, I have a master set of 4 worksheets. One worksheet is more or less the "Data" and there are several named ranges on this sheet. The other three sheets are a series of summaries with formulas referencing the "Data" sheet. The macro I'm writing is designed to create a copy of the four tabs within the same workbook. The user can then customize the other tabs as needed to get a different view. The problem that I'm having is with the named Range conflict box. When manually copying the set, I would select "No" from the dialog box and then enter my new name for the new sheets then the new summary sheets will only reference the "Data" sheet that was just created. However there are about 25 named ranges, so this process is tedious and the main reason for developing the macro. I'm looking for a way to automate the Copy/paste of tabs and then to also us a single input box to rename all of the new copied named ranges into the new tabs. I've created a very simple example file with some simple code (in CopySheets Module) that demonstrates the issue. The idea would be to click the "Copy Sheets" button on Tab 3 and bypass the error but default to "No" on the dialog box rather than "yes". Let me know if there is anything unclear about the way I've described this, or if there is any other information needed for the issue.

Thanks in advance for your help!!

Thanks,
Mike

NamedRangeExample.xlsb

Hey Ron,

Thanks for the quick response!

This is one of those moments where I'm not sure why I didn't think of that! Always gotta remember that sometimes the simplest answer is the right answer and not everything needs to be a VBA solution!

Thanks,
Mike