View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Derek Dowle Derek Dowle is offline
external usenet poster
 
Posts: 12
Default Screen flickers while macro is running

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