Looking for workarounds for CopyCutMode

[Xceller]

Hi all - Using the code below I can't clear the clipboard, the range still selected after copy and paste. Obviously, "Application.CutCopyMode = False" failed. Is there a way to deselect/clear? Using Excel 2010. Thanks

Please Login or Register  to view this content.

[jaslake]

Hi Xceller

Does this work for you?

Please Login or Register  to view this content.

[LJMetzger]

jaslake did a great job avoiding the clipboard.

On Excel 2003 (I know you have 2010), Application.CutCopyMode works for me. I was able to come up with another routine courtesy of Chip Pearson (please note api declarations missing from routine, but are included in the test routine below):

Please Login or Register  to view this content.

The following is a test program program that attempts to clear the Clipboard buffer using both:
a. Application.CutCopyMode = False
b. LJMEmptyClipBoard

The routine requires 'Microsoft Forms 2.0 Object Library'
'In VBA Tools -> References -> Microsoft Forms 2.0 Object Library
'or you will get a "Compile error: user-defined type not defined"

Please note that the Win64 api declarations have not been tested and if any are incorrect, I would appreciate knowing what the correct declarations should be.

Please Login or Register  to view this content.

Lewis

[Xceller]

jaslake - your solution is simple and slick. Thank you so much.


LJMetzger / Lewis - Thank you for your recommendation. I will try your approach a little later.

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.