hiding processes

[marta]

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

 

[Frank Kabel]

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

 

[Chip Pearson]

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