LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 93
Default 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?!?!?!?!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
locking a sheet Brooks[_2_] Excel Discussion (Misc queries) 2 March 9th 08 11:16 PM
row locking, instead of file locking? Bob W Excel Discussion (Misc queries) 2 September 7th 07 09:36 PM
Locking a row Diamontina Cocktail New Users to Excel 2 May 15th 07 10:30 PM
locking formula in cells in without locking whole sheet SuziQ Excel Discussion (Misc queries) 1 July 21st 06 03:58 PM
Locking down a tab GGanders Excel Discussion (Misc queries) 2 June 14th 06 07:49 PM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"