echo on/off - does vba for excell support?

[Paul Isaak]

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

 

[Guest]

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

 

[Nader]

Application.ScreenUpdating = False

 

[Paul Isaak]

Thanks

That helps a lot


Paul

--
__________________________________

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



Toll Free - 1-877-852-4590