Stopping clipboard warning coming up

[RyanD]

My VB script copies data from one workbook and pastes it into a new workbook. It then closes the first workbook on which, I am being prompted as to whether i want to save the data on the clipboard.

Is there any way to stop this coming up? I don't want to save what's on the clip board.

XL2000

Thanks,

Ryan

 

[dawsona]

If you put in the line:

Application.DisplayAlerts = False

this will turn off all warnings. If you need to turn them back on then change false to true otherwise it will reset when the macro ends.