VBA to clear the clip board

[bdouglas1011]

We have a pretty large workbook with a bunch of code. I keep running into an error from time to time at the weirdest times. Sometimes you will just be copying and pasting into the same or other workbooks and for no reason you will get a error saying you can not complete the task because the clipboard is being used by another program. At that point all the code stops working. The only way to fix it is to close all excel sheets that are open and then reopen then they will work again.

We work remotely and when I copy and paste remotely or a macro runs on a machine you are remotely working on ...I can see the clipboard of excel sheets on the computer I use to remote in with its clipboard has all the copy and paste events from the remote computer.

I have tried all the versions of having a macro clear the clip board but they never actually clear it.

I thought the macros were being interrupted and after the events were disabled they just are not getting re-enabled but I went thru and put things into place on error to reenable everything.

I even tried having a macro button just run and re-enables the events, but that does not work.

ex:

Please Login or Register  to view this content.

I would like to find a macro that will clear the clipboard as we go along automatically and a macro that would reenable the sheet to get it working without having to save & close all of them open and then reopen.

I wish I could get the event to happen when I want but it is random and never happens on the same worksheet.

Any thoughts or suggestions.

[CheeseSandwich]

Please Login or Register  to view this content.

[bdouglas1011]

Should I place that in all the macros and where is the best placement for it?

[CheeseSandwich]

Yes place it in the macro,

I use it after a large paste operation OR I will use it at the end of the sub to make sure we empty the clipboard after code as it can get cluttered.

[nordicdust]

There is a difference between the windows clipboard and excel clipboard.


Reads here: https://www.automateexcel.com/vba/clear-clipboard/

Excel VBA Clear Clipboard
Clearing the clipboard in Excel VBA only requires a single line of code:

Please Login or Register  to view this content.

vba clear clipboard

However, this is different from the standard Windows clipboard. To clear the Windows clipboard you can use the EmptyClipboard Function. Copy and paste the code below into a code module and run Sub TestClipboardClear to clear the Windows clipboard.

Please Login or Register  to view this content.