The simplest way is to turn the screen updating off. At the beginning of
your code put...


Application.screenupdating = False

They they might complain that they can't see anything happening. If
this is the case, true giving an occasional indication that something
is going on by setting the value of the status bar e.g.

Application.StatusBar = "Just started...."
...
...
...
...
Application.StatusBar = "Almost finished...."
...
End Sub


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=552653