Why does application.screenupdating = False is not working

[ThrottleWorks]

Hi,

This is a problem I face every day.
I have a macro with multiple modules, for example 10 modules. I am calling all the 9 modules from first module.

At every module, at start I have screen updating to false and at the end, set to true.
Still, when I run macro, I can see screen updating in progress.

How can I avoid this, can anyone please help me this.

 

[NARAYANK991]

Hi Sachin ,

Why not turn Screen Updating OFF in the main module , and turn it ON again also in the main module , after all the 9 sub-modules have been called ?

Narayan

 

[ThrottleWorks]

Good evening @NARAYANK991 sir, thanks a lot. It is working.

 

[Debaser]

If you have routines that may run on their own or be called from somewhere else, you can store the initial value of ScreenUpdating and then reset it:

Sub foo()
Dim bUpdate as Boolean
bUpdate = Application.Screenupdating
Application.Screenupdating = False

' rest of the code here

Application.Screenupdating = bUpdate
End Sub

That way, when you call it from another sub that had already turned screen updating off, it won't turn it back on when it ends - it leaves that up to the calling routine. You can also simply leave out the line that sets it back to True, or use a class module.

 

[ThrottleWorks]

Thanks a lot @Debaser , good night.