View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Atreides Atreides is offline
external usenet poster
 
Posts: 41
Default Screen Updating problem with nested subroutines

I have a problem with the screen updating not working when using nested
subroutines. i.e.

Sub main()

Application.ScreenUpdating = False
nestedSub
Application.ScreenUpdating = True

End Sub

Sub nestedSub()

Application.ScreenUpdating = False
Code here...
Application.ScreenUpdating = True

End Sub

If I run nestedSub, there is no screen flicker. However if I run main, there
is flickering the whole time (as it calls nestedSub)

How can I get it so that if I run main, it only updates the screen after
ending main, not after running nestedSub and main?

Thanks
Atreides