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/Flickering


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
when it reaches line Sheet3.Activate
Is there any way to stop this from happening?

Thanks,
edul