Locking Up
 

Now When I use this formula:

Application.DisplayAlerts=False

Windows("Book1").Close SaveChanges:=False
Windows("Book2").Activate
Cells.Select
Selection.Copy
Windows("Book2").ActivatePrevious
Range("A1").Select
ActiveSheet.Paste
Application.DisplayAlerts = True

Windows("Book2").Close SaveChanges:=False

everything works, BUT there is an alert that follows the closing of Book2.
SO, I went ahead and figured I would move the Application.DiplayAlerts=True
after the Book2 closing to avoid the alert. However, when I do that
everything just stops and locks up, forcing me to close and restart. What
gives?!?!?!?!