Thank you! That worked.

When the new copy opens up it is asking me if I want to save it even though the new copied file already in its correct folder. Is there a way to bypass this popup?

My macro on the master workbook continues running on the new copy workbook instead of the master workbook. It is not closing the ActiveWorkbook copy. Do you know how to remedy this?