Re: Macro help

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Nick Hodge (nick_hodgeTAKETHISOUT_at_zen.co.uk.ANDTHIS)
Date: 12/29/04 

Date: Wed, 29 Dec 2004 19:09:33 -0000

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS
"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.
>
>
Quantcast