I would like to turn off screen updating while my sub runs. If I turn off
screen updating within the sub, it does not turn off. If I turn off screen
updating in a second sub that calls the first, it turns off.
Any thoughts why I have to use the 2nd sub - I would prefer to accomplish
this within a single sub.
Sub Aggregate()
Dim ...
Application.EnableEvents = False
Application.ScreenUpdating = False
Load frm_Offsets
"do VBA stuff"
Application.ScreenUpdating = True
Application.EnableEvents = True
End Sub
Sub Spread_test()
Application.ScreenUpdating = False
Call Aggregate
End Sub
Thanks in advance!
Jim Rech - 17 Apr 2008 00:24 GMT
It should work the same in either case. There's got to be something else
going on. Anyway the ScreenUpdating in Aggregate is getting skipped? Can
you repro this in a simpler example?

Signature
Jim
>I would like to turn off screen updating while my sub runs. If I turn off
> screen updating within the sub, it does not turn off. If I turn off
[quoted text clipped - 20 lines]
>
> Thanks in advance!
Gary Keramidas - 17 Apr 2008 01:43 GMT
it's hard to say. try adding something like this and see if it's ever set to
false
Debug.Print Application.ScreenUpdating
Application.EnableEvents = False
Application.ScreenUpdating = False
Debug.Print Application.ScreenUpdating

Signature
Gary
>I would like to turn off screen updating while my sub runs. If I turn off
> screen updating within the sub, it does not turn off. If I turn off screen
[quoted text clipped - 19 lines]
>
> Thanks in advance!