Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
ScreenUpdating = False not working | Excel Programming | |||
ScreenUpdating = False not working | Excel Programming | |||
What does ScreenUpdating = False do? | Excel Worksheet Functions | |||
Using the Application.ScreenUpdating = False? | Excel Programming | |||
Application.screenUpdating = False | Excel Programming |