Good Morning,

I am using a spreadsheet as a template to format headers for imported
spreadsheets. Once the file is open, I use a macro that opens the template
file, copies the necessary data, pastes the data in the imported file, and
then closes the template file.

The problem is in closing the template file, the macro hangs because a
dialogue box pops up prompting whether to keep the copied data on the
clipboard. Is there a way to override this and select "No" as the option?

Thanks