View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Screen Updating problem with nested subroutines

Remove the screenupdating code from "nestedSub"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Atreides" <atreides1AThotmailD0Tcom
wrote in message
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