View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Simon Lloyd[_511_] Simon Lloyd[_511_] is offline
external usenet poster
 
Posts: 1
Default display in excel stays blank

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

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