VBA code to clear the Windows clipboard (better than application.cutcopymode = false)

[Cells.Select]

I have a bunch of excel macros running back-office functions, and my users were accidentally copying out data that had been copied by VBA macros into other places (this is not good).
I did some googled and found the typical "just use application.cutcopymode = false" answer all over the internet.

Unfortunately this does not work, at least not in Windows 10 with Excel in office 365, so I had to be creative.

I found a good starting place on this post: vbaexpress.com/kb/getarticle.php?kb_id=205
This pointed me in the right direction, and after some small changes I found a way to clear my clipboard every time.

Here is the code, with my comments:

'THE CODE BELOW WAS CREATED AND PUT IN ALL TRACKERS TO STOP USERS FROM COPYING OUT CONFIDENTIAL DATA ACCIDENTALLY
'IT WORKS BY CLEARING THE WINDOWS CLIPBOARD ENTIRELY

Please Login or Register  to view this content.

[Kaper]

Welcome to the forum.

Please take a moment to add the tags. Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

Moreover - this sub forum is for asking questions and solving problems. Your post fits into scope of https://www.excelforum.com/tips-and-tutorials/

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html

I have moved this post to Tips

(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)