Empty clipboard

[Jeff]

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

 

[FSt1]

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

 

[Ron de Bruin]

Hi Jeff

After the paste line add this line to clear the clipboard

Application.CutCopyMode = False