Andy

Application.DisplayAlerts = False

Turn them back on before code exits

If you still get the clipboard one then you could try

Application.CutCopyMode = False

or copy a blank cell

Range("A65536").Copy
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"andy" wrote in message
...
I have a macro that does certain functions on startup of my worksheet,
during
startup it collects info from a main file then pastes that info into the
worksheet. I was wondering if there is a line of code that selects yes
when
the message box comes up and asks if you would like to 'replace the
contents
of the desination cells'. Also is there a line of code that will select no
when it asks if you would like to save the large amount of information on
the
clipboard.