Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sorry simon,
I didn't notice any difference, but of cource could there be a reason to write as you suggest in other circumstances. Look at my other posting about my matter. /Regard "Simon Lloyd " skrev i meddelandet ... Try these lines i use them and experience no flicker! End With Application.Cursor = xlWait Application.EnableEvents = False ActiveWorkbook.PrecisionAsDisplayed = False Application.ScreenUpdating = False ***YOUR CODE*** Application.ScreenUpdating = True ActiveWorkbook.PrecisionAsDisplayed = True Application.EnableEvents = True Application.Cursor = xlDefault HTH Simon --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to set Application.ScreenUpdating = False for Gen use | Excel Discussion (Misc queries) | |||
What does ScreenUpdating = False do? | Excel Worksheet Functions | |||
Screen flicker despite ScreenUpdate = False in the first line of code | Excel Programming | |||
Application.ScreenUpdating = False | Excel Programming |