Hello

I using code to open an excel sheet and copy all the contents of that
sheet to another excell sheet.

I then go back and close the first sheet.

I get a prompt for the user that the clipboard contains a lot f data
and do you want to save this yes or no.

How can I in code clear the clipboard and stop this user prompt

Many thanks

Try

Application.CutCopyMode = False


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
(email address is on the web site)



"Super Slueth" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello
>
> I using code to open an excel sheet and copy all the contents of that
> sheet to another excell sheet.
>
> I then go back and close the first sheet.
>
> I get a prompt for the user that the clipboard contains a lot f data
> and do you want to save this yes or no.
>
> How can I in code clear the clipboard and stop this user prompt
>
> Many thanks