hi,
somewhere before the close put this in the macro
Application.displayalerts = false
and before end sub
Application.displayalerts = true.
when turning off a built in excel function to run a macro, always turn in
back on BEFORE you exit the sub.

Regards
FSt1

"Jeff" wrote:

Hi,

This might be a dumb question. I have a macro - it opens a workbook, copies
a range, pastes the range in the original workbook, then closes the workbook
that was opened in the first place.

It promps to save the clipboard - how do you turn this off?

Thanks for your help