Copied data prompt

[RichardDC]

I'm writing a macro that opens one file, copies the data, closes th
file opens another spreadsheet, pastes the data and then runs anothe
macro.

The macro works but I want to get rid of or answer "yes" to the promp
that asks you if you wish to keep the copied data in the clipboard s
that once the macro runs you don't have to answer any prompts

 

[Roadie]

You should put the DisplayAlerts on False:
Application.DisplayAlerts = False

and just before the end of the macro, you'll put it on again:
Application.DisplayAlerts = Tru

 

[RichardDC]

Many thanks. Works fine