Thread: Screen Updating
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben[_10_] Ben[_10_] is offline
external usenet poster
 
Posts: 3
Default Screen Updating

Hello,
If I want to stop the macro from flashing between sheets I use
Application.ScreenUpdating False and it works perfectly. However it is not
effective when I call the procedure that contains it from another procedure.
Is there a way round this. Thank you.