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


Hi all,
I have a macro that is called from another that includes the following
2 lines at the start

Application.ScreenUpdating = False
Sheet3.Activate
code here

Everytime this runs the screen jumps from another worksheet to Sheet3.
Is there any way to stop this from happening?