Cutting and pasting annoyance

[TSH]

I frequently copy large amounts of data in msexcel.
So often I get the warning that the amount on clipbaord is too large to
keep.
Is there a way to turn this off in: properties, registry, whatever...
I would be happy if it always assumed that it is ok to dump the clipboard
contents.

 

[Dave Peterson]

When are you getting this message--when you're closing the workbook (or closing
excel)?

If yes, you can hit the escape key to stop that warning. It clears Excel's
clipboard, too.

 

[TSH]

Thanks.
Either action will do this.
The fact that you are asking makes me think I did not explain this well.


I open a file, click on one of the columns, then Ctrl-C, click X to close
the app or the workbook.
The message is something like: "There is a large amount of data copied,
press yes to save it on the clipbaord or NO to dump", cancel button will
skip the close action.

Anyhow, the point is that, having to press a key (escape or NO) is the
annoyance, when one has to do it many many times during routine opreation.

Anythints will be appreciated.

----------

 

[Dave Peterson]

You can paste it to where you want it, then copy a smaller (one cell) range.

Or hit the escape key.

You could create a macro that consisted of this:

sub clearclipboard()
application.cutcopymode = false
end sub

But then you'd have to run that macro and for me, there's not too much
difference between clicking a button to start a macro and clicking a button to
say dump it/keep it.