ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to disable "There is a large amount of data on the clipboard..." (https://www.excelbanter.com/excel-discussion-misc-queries/196607-how-disable-there-large-amount-data-clipboard.html)

Bill Board

How to disable "There is a large amount of data on the clipboard..."
 
Is there away in Excel to disable the prompt "There is a large amount of
data on the clipboard..."

Thanks,
Bill



Dave Peterson

How to disable "There is a large amount of data on the clipboard..."
 
Manually?

Select a single cell and edit|copy

In code:
application.cutcopymode = false



Bill Board wrote:

Is there away in Excel to disable the prompt "There is a large amount of
data on the clipboard..."

Thanks,
Bill


--

Dave Peterson

Bill Board

How to disable "There is a large amount of data on the clipboard..."
 
No setting in excel preferences to suppress this dialog?

"Dave Peterson" wrote in message
...
Manually?

Select a single cell and edit|copy

In code:
application.cutcopymode = false



Bill Board wrote:

Is there away in Excel to disable the prompt "There is a large amount of
data on the clipboard..."

Thanks,
Bill


--

Dave Peterson




Dave Peterson

How to disable "There is a large amount of data on the clipboard..."
 
Not that I know.

Bill Board wrote:

No setting in excel preferences to suppress this dialog?

"Dave Peterson" wrote in message
...
Manually?

Select a single cell and edit|copy

In code:
application.cutcopymode = false



Bill Board wrote:

Is there away in Excel to disable the prompt "There is a large amount of
data on the clipboard..."

Thanks,
Bill


--

Dave Peterson


--

Dave Peterson

BizMark

Bill Board wrote:

No setting in excel preferences to suppress this dialog?


Yes.

Application.DisplayAlerts = False

Regards,
Mark

Dave Peterson

How to disable "There is a large amount of data on the clipboard..."
 
That doesn't sound like a setting to me.

And if the OP didn't like
application.cutcopymode = false
why would this be better?

BizMark wrote:

Bill Board wrote:

No setting in excel preferences to suppress this dialog?


Yes.

Application.DisplayAlerts = False

Regards,
Mark

--
BizMark


--

Dave Peterson


All times are GMT +1. The time now is 11:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com