echo on/off - does vba for excell support?

's Computer Specifications

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

's Computer Specifications

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
>
>
>

's Computer Specifications

Application.ScreenUpdating = False

"Paul Isaak" <(E-Mail Removed)> 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
>

's Computer Specifications

Thanks

That helps a lot

Paul

--
__________________________________

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

Toll Free - 1-877-852-4590
"Paul Isaak" <(E-Mail Removed)> 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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
NF325-A7 Sound problem: sounds like an echo ,,echo...echo makes me crazy...crazy...crazy...help...help...help	David Sontag	DIY PC	17	30th Nov 2007 06:45 AM
Echo multiple messages separated by new line thorugh "echo" command	Vijay Jain	Windows XP General	1	12th Dec 2006 09:11 PM
MMC 9.15 - Echo, echo while viewning TV...	andre	ATI Video Cards	2	22nd Aug 2006 10:22 PM
applicaton.echo / docmd.echo screen still pulsing - Why?	Rick A	Microsoft Access Form Coding	1	30th Mar 2006 04:01 AM
Application.Echo or DoCmd.Echo in a Runtime Database	=?Utf-8?B?cmJt?=	Microsoft Access Form Coding	1	23rd Jan 2004 02:54 AM