Thread: Can I stop Excel program flashing on screen during run
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Masked Coder[_5_] Masked Coder[_5_] is offline
external usenet poster
  
Posts: 1
Default Can I stop Excel program flashing on screen during run
This will work for the main Excel window

Put this at the beginning of your code:
Application.ScreenUpdating = False

and this at the end:
Application.ScreenUpdating = Tru

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote