View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default echo on/off - does vba for excell support?

Application.Screenupdating = False
'Your code
Application.Screenupdating = true
--
HTH...

Jim Thomlinson


"Paul Isaak" wrote:

I want to hide the screen while a script is running, so I don't have to
watch the screen flash as data is inserted.

with other languages I've used the echo on/off command to achieve this, but
I don't see anything similar in excel VBA for excel 97


Any Ideas?

Paul
--
__________________________________

The Comedy & Juggling of Paul Isaak
http://www.funnyjuggler.com



Toll Free - 1-877-852-4590