Application.Displayalerts will prevent these kinds of messages from popping
up and will "usually" take the action desired.

"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.