Re: Macro help

From: Bob Umlas (rumlas_at_kpmg.com)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 14:08:52 -0500

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

"andy" <andy@discussions.microsoft.com> wrote in message
news:852C7F96-8F8D-492C-A28C-30A6619EAD17@microsoft.com...
> I have a macro that does certain functions on startup of my work***,
during
> startup it collects info from a main file then pastes that info into the
> work***. 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.
>
>