hiding processes
 

Hello,
The macro i am working on has a number of processes that
involve copying information from one file to the other.
This causes the screen to 'flash' for a period of time. Is
there any way to make some of these processes invisible.
(I'm worried that this might confuse the people that will
be running it)
Thanks for your help.
marta

hiding processes
 

hi
use
application.screenupdating=false
'your code
application.screenupdating=True




--
Regards
Frank Kabel
Frankfurt, Germany


marta wrote:
Hello,
The macro i am working on has a number of processes that
involve copying information from one file to the other.
This causes the screen to 'flash' for a period of time. Is
there any way to make some of these processes invisible.
(I'm worried that this might confuse the people that will
be running it)
Thanks for your help.
marta

hiding processes
 

Marta,

Set the ScreenUpdating property to False, run your code, and then
restore it to True. E.g.,

Application.ScreenUpdating = False
' your code here
Application.ScreenUpdating = True

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"marta" wrote in message
...
Hello,
The macro i am working on has a number of processes that
involve copying information from one file to the other.
This causes the screen to 'flash' for a period of time. Is
there any way to make some of these processes invisible.
(I'm worried that this might confuse the people that will
be running it)
Thanks for your help.
marta