View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default ScreenUpdating = FALSE

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

--


Gary


"Cinque Terra" wrote in message
...
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!