Echo off

[daniels012]

I know in Access when you run a macro you can turn the echo on or off
so you don't have to watch the macro being executed. Is there cod
that I can add to do the same in excel?????

Any help I would appreciate it!

Michae

 

[tommy03]

use this :

application.displayalerts=false

(and of course, changing it to "true" turns it back on

 

[Frank Kabel]

Hi
application.screenupdating=false

 

[daniels012]

Tried that!
It did not work!

Any other ideas?

Michae

 

[tommy03]

oops !

I'm having a bad day of brain-cramps today

it's :

application. screenupdating=false

(sorry 'bout that) :rolleyes

 

[daniels012]

Thank You so much!!!!!!!!
That worked Frank.
I always see you helping others as well as myself in the past. I hop
that I can help you one day in the future!

Michae

 

[Frank Kabel]

Hi
see my post. use application.screenupdating=false