Clear Clipboard RRS feed

  • Question

  • Hi

    I have some VBA code which does a lot of copy / paste. I want to be able to clear the clipboard after I have finihsed all the copy /paste activity.

    At present when the user tries to close the file he gets a message that there is a lot of data on the clipboard - do they want to save or discard it?

    It would helpful if I could clear the clipboard before we get to this stage.

    any ideas please?



    Thursday, April 27, 2017 3:49 PM


  • The line

    Application.CutCopyMode = False

    will clear the Excel clipboard.

    Regards, Hans Vogelaar (

    • Marked as answer by py1 Thursday, April 27, 2017 4:04 PM
    Thursday, April 27, 2017 3:56 PM

All replies