Clear the clipboard

Good afternoon Macdave_19

Originally Posted by Macdave_19

I'm trying to clear the clicpboard using VBA so i don't get messages asking me what to do.

The clipboard is a Windows object, so clearing it via VBA requires the use of APIs. Chip Pearson shows how to do it here, if you're still reading (don't worry - it's only a little routine)

Alternatively, you can use this instruction :

Application.CutCopyMode = False

It will stop the "marching ants" and stop VBA bugging you with alerts, but it won't clear the clipboard.

HTH

DominicB

thankls guys that solves the problem of me getting a prompt when the workbook is closed