View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Runnig macros in background mode

Application.ScreenUpdating = false

at the top and at the bottom

Application.ScreenUpdating = True

Regards,
Tom Ogilvy


"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