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

Regards

Trevor


"peteriks" wrote in
message ...

Hi

When running a macro, there is no need to display the steps macro is
executing, how I can switch it off :)
Thanks
Peter


--
peteriks
------------------------------------------------------------------------
peteriks's Profile:
http://www.excelforum.com/member.php...o&userid=37011
View this thread: http://www.excelforum.com/showthread...hreadid=567330