echo on/off - does vba for excell support?

P

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
 
J

Jim Thomlinson

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

hide userform, but keep values 1
populating form with Palm Destop record 1
vbCrLf displays as ? in formfields 3
VBA equivalent to "echo off" 1
VBA equivalence tp to DOS "echo off" 3
excel internet explorer interaction appearance 3
Excel VBA reference docs? 0
Excel screen opens off-center 1

Top