echo on/off - does vba for excell support?
 

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

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

echo on/off - does vba for excell support?
 

Application.ScreenUpdating = False

"Paul Isaak" wrote in message
news:1W35h.287651$1T2.99892@pd7urf2no...
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

echo on/off - does vba for excell support?
 

Thanks

That helps a lot


Paul

--
__________________________________

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



Toll Free - 1-877-852-4590
"Paul Isaak" wrote in message
news:1W35h.287651$1T2.99892@pd7urf2no...
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