Excel - How to disable "There is a large amount of data on the clipboard..."

Asked By Bill Board on 28-Jul-08 04:15 PM
Is there away in Excel to disable the prompt "There is a large amount of
data on the clipboard..."

Thanks,
Bill




Dave Peterson replied on 28-Jul-08 04:47 PM
Manually?

Select a single cell and edit|copy

In code:
application.cutcopymode = false




--

Dave Peterson
Bill Board replied on 29-Jul-08 09:41 AM
No setting in excel preferences to suppress this dialog?
Dave Peterson replied on 29-Jul-08 10:17 AM
Not that I know.


--

Dave Peterson
BizMark replied on 29-Jul-08 04:46 PM
Yes.

Application.DisplayAlerts = False

Regards,
Mark




--
BizMark
Dave Peterson replied on 29-Jul-08 06:10 PM
That does not sound like a setting to me.

And if the OP did not like
application.cutcopymode = false
why would this be better?


--

Dave Peterson