Clear the clipboard

Hi All

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

is this possible and if so how?

i could simply turn all alerts off but i rather not

thanks all

To clear the Excel clipboard,

Please Login or Register  to view this content.

Clearing the Office clipboard require Windows API.

Why not suppress alerts?

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 :

Please Login or Register  to view this content.

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