Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Usually the code
Application.ScreenUpdating = False and Application.ScreenUpdating = True switches off and then switches on screen updating successfully without any problems. 'Private Sub Worksheet_Activate()' of a worksheet calls a macro in the Modules. This macro jumps between worksheets to gather information. The ScreenUpdating keeps the screen focused on the activated worksheet whilst the macro is running. Whilst the macros is running the active screen flickers. The macro does everything else asked of it. What is the code please to stop the screen from flickering. Many thanks -- Derek Dowle |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Screen flickers and text disappears/moves?? | Excel Discussion (Misc queries) | |||
Screen Flickers and slows down worksheet functions | Excel Programming | |||
Display Problem in Excel 2007: Screen flickers an rows blanked out | Excel Discussion (Misc queries) | |||
Screen "Flickers" When macro Starts !! | Excel Programming | |||
Spreadsheet screen flickers for a few second when using a condition | Excel Programming |