Thread: display in excel stays blank
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default display in excel stays blank


Application.ScreenUpdating = False

''do your stuff

Application.ScreenUpdating = True

Gord Dibben Excel MVP

On Wed, 23 Jun 2004 16:40:39 -0500, calculus87
wrote:

Okay,
I am running several macro's in excel. While these macro's are
running,spreadsheets are continually appearing on the screen (either
being opened, or coming to the front of the other pages). I don't want
this to happen. I would like to have a blank display while my marco's
are running. I am not sure how to do this. If you could send me some
code, or help me out in some way that would be great. Thanks


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

Reply With QuoteReply With Quote