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