Large amount of info on the clipboard

[ledzepe]

Hi everybody,

My macro program involves moving large amount of info from one sheet to another. I keep getting the message that "There is a large amount of information on the Clipboard..." and is giving me the option to save it or delete those info. I don't need those info anymore so I just click on "No".

Is there a way to disable this message via macro or setting in Excel/Windows?

[Trevor Shuttleworth]

ledzepe

Application.DisplayAlerts = False
' your code
Application.DisplayAlerts = True

Regards

True


"ledzepe" <[email protected]> wrote in
message news:[email protected]...
>
> Hi everybody,
>
> My macro program involves moving large amount of info from one sheet to
> another. I keep getting the message that "There is a large amount of
> information on the Clipboard..." and is giving me the option to save it
> or delete those info. I don't need those info anymore so I just click on
> "No".
>
> Is there a way to disable this message via macro or setting in
> Excel/Windows?
>
>
> --
> ledzepe
> ------------------------------------------------------------------------
> ledzepe's Profile:
> http://www.excelforum.com/member.php...o&userid=25207
> View this thread: http://www.excelforum.com/showthread...hreadid=518028
>

[Dave Peterson]

Application.cutcopymode=false

is another way.

ledzepe wrote:
>
> Hi everybody,
>
> My macro program involves moving large amount of info from one sheet to
> another. I keep getting the message that "There is a large amount of
> information on the Clipboard..." and is giving me the option to save it
> or delete those info. I don't need those info anymore so I just click on
> "No".
>
> Is there a way to disable this message via macro or setting in
> Excel/Windows?
>
> --
> ledzepe
> ------------------------------------------------------------------------
> ledzepe's Profile: http://www.excelforum.com/member.php...o&userid=25207
> View this thread: http://www.excelforum.com/showthread...hreadid=518028

--

Dave Peterson