Screen Updating

[Ben]

Hello,
If I want to stop the macro from flashing between sheets I use
Application.ScreenUpdating False and it works perfectly. However it is not
effective when I call the procedure that contains it from another procedure.
Is there a way round this. Thank you.

[Jim Thomlinson]

You should not be toggling screen updating in every procedure. Every time you
see

Application.Screenupdating = True

You will get a flash. Your code should look something like this

Sub This()
Application.Screenupdating = False
Call That
Application.Screenupdating = True
End sub

Sub That
Application.Screenupdating = False 'Not here

Application.Screenupdating = True 'Not here
End sub

If there is a Application.Screenupdating = True in "Sub That" then you will
get a flash at that point the sub ends.

--
HTH...

Jim Thomlinson


"Ben" wrote:

> Hello,
> If I want to stop the macro from flashing between sheets I use
> Application.ScreenUpdating False and it works perfectly. However it is not
> effective when I call the procedure that contains it from another procedure.
> Is there a way round this. Thank you.
>
>
>

[Leith Ross]

Hello Ben,

From what you descibe the problem isn't with the macro, but with the calling procedure. It sounds like the calling procedure is updating the screen before your macro is executed. Place the Application.ScreenUpdating function in the calling procedure and it should be ok. There are instances however where Application.ScreenUpdating will not prevent the screen from flickering.

Sincerely,
Leith Ross