Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
locking a sheet | Excel Discussion (Misc queries) | |||
row locking, instead of file locking? | Excel Discussion (Misc queries) | |||
Locking a row | New Users to Excel | |||
locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
Locking down a tab | Excel Discussion (Misc queries) |