Jacob

As you will have seen by my reply to Patrick's helpful response I was
expecting something different. I will make a proper record of your answer
on this occaision.

Thank you
--
Derek Dowle


"Jacob Skaria" wrote:

I understand the macro is called from the activate event...try....

Application.EnableEvents = False
Application.ScreenUpdating = False
'call macro
Application.EnableEvents = True
Application.ScreenUpdating = True

--
If this post helps click Yes
---------------
Jacob Skaria


"Derek Dowle" wrote:

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