display in excel stays blank

C

calculus87

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

Simon Lloyd

I dont know how to display a blank sheet except perhaps you should add
sheet call it some name like "hidden" then hide it then you can call i
and hide it after your events something like this

Worksheets("hidden").Visible = True
Worksheets("hidden").Select
With Application
.EnableEvents = False
.ScreenUpdating = False
End With
Worksheets("hidden").Visible = False

Put the last line before your end sub of your code, and the rest at th
begining of your code.

I'm fairly new to this so it may take some tweaking, there are loads o
clever people on here who an give you a hand if that doesnt wor
properly!

HTH

Simo
 
G

Gord Dibben

Application.ScreenUpdating = False

''do your stuff

Application.ScreenUpdating = True

Gord Dibben Excel MVP
 
Top