ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Runnig macros in background mode (https://www.excelbanter.com/excel-programming/273713-re-runnig-macros-background-mode.html)

Tom Ogilvy

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





All times are GMT +1. The time now is 02:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com