Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ScreenUpdating not working
Excel XP, Win XP
The code below is an abbreviation of my code just to illustrate my problem. The code simply opens the "One.xls" file, copies from "One.xls" and PasteSpecial xlPasteValues to file "Two.xls", closes the "One.xls" file, and activates the "Two.xls" file. The code works fine. No problem there. The problem is that the screen jumps around during the Copy/Paste process even though I have ScreenUpdating set to False. Am I missing something with ScreenUpdating? Thanks for your time. Otto Application.ScreenUpdating = False Workbooks.Open Filename:=.."One.xls" With Workbooks("Two.xls").Sheets("TheSht") Cells.Copy .Range("A1").PasteSpecial xlPasteValues End With Application.DisplayAlerts = False ActiveWorkbook.Close SaveChanges:=False Application.DisplayAlerts = True Windows("Two.xls").Activate Sheets("TheSht").Activate Application.ScreenUpdating = True |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ScreenUpdating = False not working | Excel Programming | |||
ScreenUpdating = False not working | Excel Programming | |||
ScreenUpdating function not working? | Excel Programming | |||
screenupdating = false not working in Workbook_open sub | Excel Programming | |||
Application.screenupdating is not working in Excel 2002 though it. | Excel Programming |