Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
.ScreenUpdating Problem?
In this code, I use the .ScreenUpdating = False/True to
speed things up and to prevent flashing through worksheets as the sub operates. I still get the "flashing" - very fast screens of the last worksheet the user saved on. Is there a way to prevent this? Sub Auto_Open() Dim ws As Worksheet Application.ScreenUpdating = False Application.DisplayFullScreen = True For Each ws In Worksheets If ws.Visible = xlSheetVisible Then ws.Select Application.GoTo ws.Range("A1"), True ActiveWindow.DisplayGridlines = False ActiveWindow.DisplayWorkbookTabs = False End If Next Worksheets("Customer").Select ActiveWindow.Zoom = 62 Worksheets("Financial").Select ActiveWindow.Zoom = 62 Worksheets("Learning and Growth").Select ActiveWindow.Zoom = 62 Worksheets("Internal Business Process").Select ActiveWindow.Zoom = 62 Worksheets("Scorecard").Select ActiveWindow.Zoom = 62 'Sizes the window to 62% ThisWorkbook.Colors(7) = RGB(255, 124, 128) Application.AutoPercentEntry = True Application.ScreenUpdating = True End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
about screenupdating | Excel Discussion (Misc queries) | |||
Screenupdating Problems | Excel Discussion (Misc queries) | |||
What does ScreenUpdating = False do? | Excel Worksheet Functions | |||
ScreenUpdating not effective | Excel Programming | |||
screenupdating command ignored | Excel Programming |