Use

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


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


"PaiolaS" wrote in message
...
I have macros in my workbook that a want to run in
background mode, and i dont want the screen changing
while the macro is running. Something like the old "echo
off" command in dos.

How can i do this?

thanks a lot