Locking Up

B

bodhisatvaofboogie

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?!?!?!?!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with activating window from Application.GetOpenFilename 4
Closing Workbooks Formula 5
Pasting Between Workbooks 1
Macro - New Workbook 3
Macro to compare, find match and copy between workbooks 6
BeforeSave event fired but not working when triggered by SaveAs. 3
VBA Filter 2
display alerts= false not working 1

Top