Any Code for Clearing the Clipboard After Paste...?

Hi all,

Anyone know if, in Excel (or in Windows in general, for that matter), there's a way to dump the clipboard AFTER AN INITIAL paste (like a "paste once" only kinda thing)? Say, I copy the word "cool" from some non-office App, then paste it in a WS. After successfully pasting this, I need an empty clipboard... It appears I ask the impossible.

Thanx,
Frith

CP Link (per forum rules):
http://www.mrexcel.com/forum/showthread.php?p=2732988

EmptyClipboard

Within Excel, you can clear Excel data from the clipboard with: Application.CutCopyMode = False. Or to completely clear the clipboard, use code like the following.

Please Login or Register  to view this content.

The Public Declare lines of code need to be in the declarations section of the module, before and outside of any procedure. If you are going to use this code within an object module (ThisWorkbook, a Sheet module, a UserForm module, or a Class module), change Public to Private.


Courtesy of Chip Pearson

http://www.cpearson.com/excel/Clipboard.aspx


Regards

Setting Application.CutCopyMode does not affect what is in the clipboard.

Excel behaves differtly in cut mode, copy mode and neither. (for example the crawly lines around the copied cells). That variable defines that behaviour not the contents of the clipboard.

One could (perhaps) clear the clipboard after each paste, but why?
You'd loose the capability to UnDo, you'ld loose the capbality to paste the same data to different part of the worksheet.
I don't see any value other than to punish a clumsy fingered user (like me).

If the goal is to protect the secrecy of the data coming from the clipboard, forget it. Excel is not a secure application. If you want to keep data a secret, keep it far away from Excel.

As mikerickson says, why would you want to do this?

However, try this example:

Please Login or Register  to view this content.

Assuming you copy and paste the code into a standard module, it will be in the clip board.

The first paste special will paste the code into the workbook. The second paste, after the column is deleted,won't paste anything in.

Best way to test this is to step through it with F8

Regards

Hi,

After pasting that code, there's no change in Excel's behavior, in A1 or elsewhere (tried low security, that public/private, declaration/worksheet thing, but nothing).

Basically, what I need -- and, yes, there is a "reason" for all of this -- is for Excel to simply act as if I just double-clicked cell Y after pasting in cell Z (i.e., clearing the clipboard, greying out the paste option, etc.) Actually, you'd think this would be on the simpler side of what's solved here.

Maybe this is more of a "Windows" issue, rather than an "Excel" one? I know there's Apps out there that will do this for me. Though, this is more of a last resort, as I really don't want my clipboard wiped out while using other Apps.

Thanx,
Frith

What can I say?

I have opened Excel 2003 and Excel 2007 and, in each case, pasted the code into an empty standard module and then stepped through it using F8. In both cases, it pastes the code starting in cell A1, clears it and then doesn't paste anything ... because it's just been cleared.

If it doesn't do that for you ... I cannot offer any other suggestions.

We seem to be going through a loop here with me testing it and saying it works and you testing it and saying it doesn't.

If there are apps out there that do what you want, it may be helpful to me and to others who may want to make use of it, if you shared the details and/or links.

Regards

Assuming you paste with Ctrl+V, in ThisWorkbook,

Please Login or Register  to view this content.

In a code module,

Please Login or Register  to view this content.

Completely untested ...

If you're pasting in a macro, then clear the clipboard in the macro after pasting.

I think shg was agreeing with you that it is a simple task ... and expected you to add the line of ocde yourself ;-)

Please Login or Register  to view this content.

Regards

TMS, I haven't been following this thread closely, but might that not be simplified?

Please Login or Register  to view this content.

On Error GoTo 0 clears any current error, so there's no need to both clear the error and then reset error handling, and error handling (but not the current error, so clearing it is good) resets when you exit the sub.

I guess it's application-dependent whether you clear the clipboard irrespective of whether you paste anything.

Thanx, but I just get "named argument not found" errors whenever I click a cell...

@shg: in all honestly, I don't know where is best to put the call. The code could probably be more efficient but I tend to leave OP code alone unless it is *really* bad (IMO).

@frith: I suspect that the ClearClipboard definitions and code need to be in a standard module rather than in the sheet code module.

In the majority of cases, you are more likely to get an early resolution of your question or problem if you post a sample workbook so the code can be seen and tested in context.

Regards

I changed

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Reckon that should be changed back.

@frith: you're welcome.

If we have managed to address your problem, please mark your thread as Solved. See my signature for details or the FAQ.

Regards